How do I use UPPER in Excel?
Use UPPER when you want to convert text to uppercase. Enter Text in that order, then add optional arguments when needed.
Excel Function
UPPER
Converts text to uppercase.
UPPER(text)Arguments
text
RequiredEnter a text value (wrap with quotes when needed).
Practice Preview
Use UPPER to convert cell B2 (Name in column B) to uppercase.
Example Table
| # | AEmployee ID | BName | CEmail | DPayment Amount | EAmount Text |
|---|---|---|---|---|---|
| 2 | E001 | tanaka taro | t.tanaka@example.com | 1200 | 1200 |
| 3 | E002 | Hanako Suzuki | h.suzuki@example.com | 980 | 980 |
| 4 | |||||
| 5 | |||||
| 6 | |||||
| 7 | |||||
| 8 |
How to Use (Formula)
=UPPER(B2)Result
TANAKA TARO
Practice This Function
UPPER FAQ
Where can I practice UPPER?
Use the "Start Function Practice" button to jump straight into UPPER drills.
What arguments does UPPER use?
The main arguments are Text. Enter them in order.