How do I use LOWER in Excel?
Use LOWER when you want to convert text to lowercase. Enter Text in that order, then add optional arguments when needed.
Excel Function
LOWER
Converts text to lowercase.
LOWER(text)Arguments
text
RequiredEnter a text value (wrap with quotes when needed).
Practice Preview
Use LOWER to convert cell B2 (Name in column B) to lowercase.
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)
=LOWER(B2)Result
tanaka taro
Practice This Function
LOWER FAQ
Where can I practice LOWER?
Use the "Start Function Practice" button to jump straight into LOWER drills.
What arguments does LOWER use?
The main arguments are Text. Enter them in order.