← Back to level 1
Level 1Next
UPPER
A easy text formula for converting letters to uppercase.
Syntax
=UPPER(...)Step-by-step explanation
- 1Understand the job that UPPER solves before you type the formula.
- 2Build or select the cells and ranges that UPPER needs before typing it.
- 3Check the output and refine the range or criteria if needed.
Common mistakes
Using it when case should stay mixed
Expecting it to change numbers or symbols
Applying it too early before extracting the text you need
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=UPPER(A1:B2)
Result
42
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =UPPER(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 42.
Practice area
Use UPPER when labels, codes, or headings need a consistent capital style.
Match against the syntax block above.