The Excel LOWER function converts every letter in a text string to lowercase — one argument, no options, available in every version of Excel. It is the go-to fix for email addresses, usernames, and URLs typed with random capitalization. Its siblings are UPPER (ALL CAPS) and PROPER (Each Word Capitalized).
=LOWER("Maria.GARCIA@Example.com") returns maria.garcia@example.com.
Syntax
| Argument | Description | |
|---|---|---|
text | Required | The text to convert — a string in quotes, a cell reference, or another formula’s result. Non-letter characters are returned as-is. |
Available in: every version of Excel, Excel for the web, and Google Sheets. LOWER only touches letters — numbers, symbols, and spacing are untouched, and a number passed to LOWER comes back as text.
Standardize emails and IDs
Email systems don’t care about case, but duplicate-detection formulas and CSV exports do. One helper column makes every address identical:
| A | B | |
|---|---|---|
| 1 | Raw entry | =LOWER(A2) |
| 2 | Maria.GARCIA@Example.com | maria.garcia@example.com |
| 3 | JWu@EXAMPLE.COM | jwu@example.com |
| 4 | Dee.Brown@example.Com | dee.brown@example.com |
| 5 | SKU-1042-W | sku-1042-w |
To replace the originals, copy the helper column, then Paste Special › Values over column A and delete the helper. In Excel 365 one formula converts the whole column at once:
Try it: interactive LOWER demo
Type anything and watch LOWER convert it — UPPER and PROPER are shown alongside for comparison.
Cleanup combos: TRIM, usernames, and keys
Imported text usually needs more than a case fix. The classic pairing trims stray spaces and lowercases in one pass:
LOWER is the standard wrapper when building usernames and email addresses from name columns:
And it makes case-sensitive tools behave case-insensitively — EXACT, FIND, and SUBSTITUTE all care about case:
Errors & common pitfalls
Pitfall: LOWER doesn’t change the original cell. Like every formula, it returns a converted copy. To overwrite the source data: helper column → copy → Paste Special › Values → delete the helper.
Pitfall: numbers and dates come back as text. =LOWER(B2) on the number 1042 returns the text “1042”, and a date comes back as its serial number in text form. Only run LOWER on actual text, or wrap the result in VALUE if math must follow.
Pitfall: you may not need LOWER for comparisons. Excel’s = operator and lookups like XLOOKUP and VLOOKUP are already case-insensitive. LOWER is for standardizing stored data, not for making lookups work.
#NAME? — typo or missing quotes. LOWER exists everywhere, so #NAME? almost always means the function name is misspelled or a literal string argument is missing its quotes: =LOWER(Dallas) instead of =LOWER("Dallas").
Practice workbook
Frequently asked questions
How do I make an entire column lowercase at once?
=LOWER(A2:A500). In older versions, enter =LOWER(A2) and double-click the fill handle to copy it down.How do I replace the original text instead of using a second column?
Does LOWER affect numbers, dates, or punctuation?
Why lowercase email addresses if email isn't case-sensitive?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class