Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inLOWER(text)
Google Sheets✔ Built inLOWER(text)
Airtable✔ Built inLOWER(string)
Notion✔ Built inlower(text)
Try LOWER with your own values
Result (as Excel & Google Sheets return it)
ada.lovelace@example.com 24 characters
Your formula, ready to paste
Excel=LOWER("Ada.Lovelace@Example.COM") open excel.new ↗
Google Sheets=LOWER("Ada.Lovelace@Example.COM") open sheets.new ↗
AirtableLOWER("Ada.Lovelace@Example.COM")
Notionlower("Ada.Lovelace@Example.COM")

Arguments

ArgumentWhat it means
textThe text to convert.

Examples

FormulaResultWhyCopy
=LOWER("Ada.Lovelace@Example.COM")ada.lovelace@example.comNormalise email addresses.
=LOWER(TRIM(A2))Clean keyA tidy value for matching or de-duplicating.
=SUBSTITUTE(LOWER(A2), " ", "-")url-slugTurn 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.

Part of the Text functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.