Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
LOWER
LOWER changes every uppercase letter in a text string to lowercase, leaving numbers and punctuation untouched. It is commonly used to normalize email addresses, usernames, or category labels before comparisons or lookups.
Excel
=LOWER(A2)Google Sheets
=LOWER(A2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Alice@Example.COM |
| BOB@SAMPLE.ORG |
| Carol@Test.Net |
| dave@DOMAIN.IO |
=LOWER(A2)→alice@example.com
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Identify the cell or text value you want to convert to lowercase.
- 2Enter =LOWER(text) referencing that cell.
- 3Apply across a range to normalize an entire column for consistent data handling.
Need a version for your data?
Try: “Normalize all email addresses in a list to lowercase before deduplication”