LOWER Function in Excel, Google Sheets, Airtable & Notion
LOWER converts every letter in a text string to lowercase. “Ada.Lovelace@Example.COM” becomes “ada.lovelace@example.com”.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | LOWER(text) |
| Google Sheets | ✔ Built in | LOWER(text) |
| Airtable | ✔ Built in | LOWER(string) |
| Notion | ✔ Built in | lower(text) |
| Excel | =LOWER("Ada.Lovelace@Example.COM") | open excel.new ↗ |
|---|---|---|
| Google Sheets | =LOWER("Ada.Lovelace@Example.COM") | open sheets.new ↗ |
| Airtable | LOWER("Ada.Lovelace@Example.COM") | |
| Notion | lower("Ada.Lovelace@Example.COM") |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
text | The text to convert. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=LOWER("Ada.Lovelace@Example.COM") | ada.lovelace@example.com | Normalise email addresses. | |
=LOWER(TRIM(A2)) | Clean key | A tidy value for matching or de-duplicating. | |
=SUBSTITUTE(LOWER(A2), " ", "-") | url-slug | Turn a title into a simple slug. |
Examples use Excel / Google Sheets syntax unless noted.
How LOWER works
LOWER is the standard first step when cleaning data that people type: email addresses, usernames, tags. Combined with TRIM it gives a reliable key for spotting duplicates with COUNTIF or UNIQUE, even though Excel and Sheets comparisons already ignore case.
It matters more in Airtable and Notion, where text comparisons and functions like FIND and contains() are case-sensitive. Lowercasing both sides, e.g. contains(lower(prop("Title")), "urgent") in Notion or FIND("urgent", LOWER({Title})) in Airtable, gives a case-insensitive match.
Frequently Asked Questions
- Is there a function for sentence case?
- Not built in. Use
=UPPER(LEFT(A2, 1))&LOWER(MID(A2, 2, LEN(A2)))to capitalise only the first letter.