UPPER
Changes text to capitals.
How it’s written
UPPER(text)Example
| A | |
|---|---|
| 1 | Name |
| 2 | amara |
=UPPER(A2)Result: AMARA
Every letter becomes a capital.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Helpful for standardizing codes before comparing them.
Practice it properly
Cleaning messy text gives you real tasks, with your formulas tested on data you haven’t seen.