E-mail clean-up
| A | |
|---|---|
| 1 | |
| 2 | [email protected] |
Formula: C2: =LOWER(A2)
Result: [email protected]
The mixed capitals in the address all become lowercase.
Google Sheets function
LOWER in Google Sheets
LOWER with worked examples you can test in the live grid. The argument details are in the Excel guide.
In Google Sheets
The arguments and common errors are covered in the LOWER Excel guide; check the function help in Google Sheets for its own argument list.
Worked examples in Google Sheets
URL slug from a title
| A | |
|---|---|
| 1 | Title |
| 2 | Annual Report |
Formula: C2: =LOWER(SUBSTITUTE(A2," ","-"))
Result: annual-report
SUBSTITUTE replaces the space with a hyphen, and LOWER makes the whole slug lowercase.
Case-blind match
| A | B | |
|---|---|---|
| 1 | Typed | Stored |
| 2 | PRO | pro |
Formula: D2: =LOWER(A2)=LOWER(B2)
Result: TRUE
After lowering both values the comparison is TRUE.
Try it
A tiny spreadsheet with example data. Edit the formula or any number and see the result.
Formula in D2: =LOWER(A2)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Text | Other | Result | |
| 2 | Alice Johnson | alice johnson | alice johnson | |
| 3 | [email protected] | [email protected] | ||
| 4 | extra spaces | |||
| 5 | SKU-2026-0415 | |||
| 6 | iced coffee, tea, sugar | |||
| 7 | Order 417 shipped |
Result in D2: alice johnson
Google Sheets is used here only as a descriptive product name. FormulaCamp is not affiliated with Google.