Excel UPPER Function
UPPER converts every letter in a text value to uppercase.
Use it to normalize product codes, IDs, state abbreviations, imported labels, or lookup keys before comparing or joining text.
1
Choose text
Use typed text, a cell, or a formula
2
Return uppercase text
Letters change; numbers and punctuation stay
UPPER syntax & arguments
Syntax
=UPPER(text)
Required
Optional
-
1
text
RequiredThe text value, cell reference, or formula result to convert to uppercase.
Example
=UPPER(A2)
Convert the text in A2 to uppercase.
UPPER caveats
-
Only letters change
Numbers, punctuation, spaces, and symbols remain in the same positions.
-
It does not clean spacing
UPPER keeps leading, trailing, and repeated spaces. Use TRIM when spacing should be cleaned too.
Need a different case? Use LOWER for lowercase text or PROPER for title case.
Intro UPPER practice problem
Solve the intro problem directly here, or open it on its own page.
Advanced UPPER practice problems
Use UPPER alongside other Excel functions in realistic, less-prescriptive challenges.
