Excel + Google Sheets · LOWER
Make any text lowercase
Turns text into lowercase. UPPER does the opposite.
The formula
=LOWER(A2)What each part means
A2The text
Example
| A | B | |
|---|---|---|
| 1 | Clean | |
| 2 | Laura.Gomez@ACME.com | |
| 3 | JOAO@Bolt.BR | |
| 4 | Priya.S@Cora.IN |
| A | B | |
|---|---|---|
| 1 | Clean | |
| 2 | Laura.Gomez@ACME.com | laura.gomez@acme.com |
| 3 | JOAO@Bolt.BR | joao@bolt.br |
| 4 | Priya.S@Cora.IN | priya.s@cora.in |
Step by step
- Click cell B2.
- Type the formula:
=LOWER(A2) - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)