UPPER
Makes all letters in text uppercase: brings codes, license plates and abbreviations to one look.
UPPER(text)- text
- The cell or text to convert to uppercase.
Return value
The same text in uppercase letters.
Examples
License plates in one style
fx
A
B
C
1
2
3
4
5
6
7
License plate
As in database
7abc123
Bkr4521
jxP8830
5Tnm012
Sheet1
Details
UPPER changes all lowercase letters to uppercase. Digits, spaces and symbols stay as they were.
Comparing with = and VLOOKUP in Excel ignore case, so UPPER is mainly for a consistent look: codes and abbreviations are usually written in capitals.
Common mistakes
- UPPER doesn't fix look-alike characters. The letter O and the digit 0 look similar in a code, but for Excel they are different characters.
- Extra spaces stay. If you need both, wrap the result in TRIM.