Text
Making a label all capitals
Definition
Turning a label into uppercase means giving UPPER the cell that holds the label.
Syntax
=UPPER(text)
Arguments
| Argument | Meaning |
|---|---|
text |
The cell that holds the label to convert. |
Worked example
A stock list keeps short bin labels in B2:B4 that need to print in capitals.
| A: Bin | B: Label |
|---|---|
| 1 | pack |
| 2 | sku |
| 3 | lot |
Formula: =UPPER(B2)
Result: PACK. Every letter in pack becomes a capital.
Practice
Cell A2 holds qty. In B2, write a formula that converts that label to 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 qty, so uppercase is QTY.
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 QTY.
The next lesson is Making a label all lowercase.
Related functions
UPPER is the function that turns the label into capitals.
Common mistake
Wrapping the cell in quotes, as in =UPPER("B2"): that converts the letters B and 2 as text and returns B2 instead of PACK.