# LOWER function in Excel

> LOWER converts every letter in a text string to lowercase and leaves numbers and symbols alone.

Source: https://spreadsheetpractice.com/functions/lower · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** LOWER converts every letter in a text string to lowercase and leaves numbers and symbols alone.
- **Syntax:** `=LOWER(text)`
- **Most common use:** `=LOWER(A2)` returns maya.chen@acme.com (A mixed-case email, normalized)
- **Available in:** Every current version
- **Category:** [Text functions](https://spreadsheetpractice.com/functions/category/text)
- **Returns:** The same text in lowercase.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

LOWER converts every letter in a text string to lowercase and leaves numbers and symbols alone. It's the standard fix for email addresses, usernames and codes that arrive in mixed case and need to look consistent.

## Syntax

`=LOWER(text)`

| Argument | Required? | What it is |
|---|---|---|
| `text` | Required | The text or cell to convert. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=LOWER(A2)` | maya.chen@acme.com | A mixed-case email, normalized |
| D3 | `=LOWER(B3)&"@"&LOWER(C3)` | rpatel@globex.io | A clean address built from two parts |
| D4 | `=LOWER(A4)=LOWER("LEE.WONG@initech.net")` | TRUE | Comparing two entries after lowercasing both |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Email (as typed) | Username | Domain | Result |
| 2 | Maya.Chen@Acme.COM | MChen | ACME.COM | maya.chen@acme.com |
| 3 | RAJ.PATEL@acme.com | RPatel | Globex.io | rpatel@globex.io |
| 4 | lee.wong@Initech.NET | LWong | INITECH.net | TRUE |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Lookups still fail after LOWER | Lookups and COUNTIF already ignore case, so the real problem is usually extra spaces. Use LOWER(TRIM(A2)). |
| The original column doesn't change | A formula can't edit another cell. Put LOWER in a helper column, then copy it and use Paste Values over the original if you need to replace it. |

## Tips

- Use EXACT when case matters. The = sign and lookups treat "ABC" and "abc" as equal.

## Related functions

- [UPPER](https://spreadsheetpractice.com/functions/upper): UPPER converts every letter in a text string to capitals.
- [PROPER](https://spreadsheetpractice.com/functions/proper): PROPER capitalizes the first letter of each word and lowercases the rest.
- [TRIM](https://spreadsheetpractice.com/functions/trim): TRIM removes spaces from the start and end of text and shrinks runs of spaces between words to one.
- [EXACT](https://spreadsheetpractice.com/functions/exact): EXACT compares two text values and returns TRUE only if they match exactly, including upper and lower case.

## Questions

### How do I change text to lowercase in Excel?

Type =LOWER(A2) in an empty column, fill it down, then copy the results and paste them as values over the original. Flash Fill (Ctrl+E) can also do it from one typed example.

### Is there a shortcut to change case in Excel?

No. Unlike Word's Shift+F3, Excel has no case shortcut. Use LOWER, UPPER or PROPER, or Flash Fill.

## Practice

A graded LOWER exercise ("Clean emails") is on [the LOWER page](https://spreadsheetpractice.com/functions/lower). It is checked instantly, then re-checked on changed data.

Lessons that use LOWER:

- [Lesson 20: Cleaning messy data](https://spreadsheetpractice.com/learn/cleaning-messy-data) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
