LOWER
Changes text to lowercase.
How it’s written
LOWER(text)Example
| A | |
|---|---|
| 1 | |
| 2 | AMARA@X.COM |
=LOWER(A2)Result: amara@x.com
Every letter becomes lowercase.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Email addresses are a typical use.
Practice it properly
Cleaning messy text gives you real tasks, with your formulas tested on data you haven’t seen.