Text
UPPER
Definition
UPPER returns a text string converted to uppercase letters.
Syntax
=UPPER(text)
Arguments
| Argument | Meaning |
|---|---|
text |
The text, or the cell holding it, to convert. |
Worked example
A dispatch desk stores parcel labels in mixed case. The labels are in B2:B4.
| A: Stop | B: Label |
|---|---|
| 1 | Parcel |
| 2 | crate |
| 3 | Bag |
Formula: =UPPER(B2)
Result: PARCEL. Every letter in Parcel is raised to uppercase.
Practice
Cell A2 holds hello. In B2, write a formula that returns that word in uppercase.
- In B2, write an UPPER formula for A2.
- B2 should show A2 in uppercase.
Step 1 of 2
Enter =UPPER(A2) in B2.
A2 is hello, so uppercase is HELLO.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
B2 uses UPPER.
B2 now shows HELLO.
Related functions
UPPER is often used before LEFT takes a prefix, and LEN still counts the same number of characters after the case change.
Common mistake
Expecting UPPER to change the source cell: B2 still holds Parcel until you replace it, so later formulas that read B2 still see the original case.