Spreadsheet formulas explained, side by side

PROPER Function in Excel, Google Sheets, Airtable & Notion

PROPER capitalises the first letter of every word and lowercases the rest. “ada LOVELACE” becomes “Ada Lovelace”.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inPROPER(text)
Google Sheets✔ Built inPROPER(text_to_capitalize)
Airtable✘ Not available—
Airtable has no PROPER and formulas can't uppercase each word. For a single word, UPPER(LEFT({Name}, 1)) & LOWER(MID({Name}, 2, LEN({Name}))) works. For several words, use a scripting automation or fix the case in a spreadsheet before importing.
Notion≈ Workaroundsplit(lower(text), " ").map(upper(substring(current, 0, 1)) + substring(current, 1, length(current))).join(" ")
Split into words, capitalise each and join them back. It only starts a new word after a space, so “mary-jane” becomes “Mary-jane”, where Excel gives “Mary-Jane”.
Try PROPER with your own values
Result (as Excel & Google Sheets return it)
Ada Lovelace 12 characters
Your formula, ready to paste
Excel=PROPER("ada LOVELACE") open excel.new ↗
Google Sheets=PROPER("ada LOVELACE") open sheets.new ↗
Airtable✘ No equivalent. Airtable has no PROPER and formulas can't uppercase each word. For a single word, UPPER(LEFT({Name}, 1)) & LOWER(MID({Name}, 2, LEN({Name}))) works. For several words, use a scripting automation or fix the case in a spreadsheet before importing.
Notion
workaround
split(lower("ada LOVELACE"), " ").map(upper(substring(current, 0, 1)) + substring(current, 1, length(current))).join(" ")

Arguments

ArgumentWhat it means
textThe text to convert.

Examples

FormulaResultWhyCopy
=PROPER("ada LOVELACE")Ada Lovelace
=PROPER("mary-jane o'neil")Mary-Jane O'NeilAny non-letter starts a new word.
=PROPER("2nd floor")2Nd FloorDigits count as non-letters too.
=PROPER("mcdonald")McdonaldPROPER doesn't know name rules.

Examples use Excel / Google Sheets syntax unless noted.

How PROPER works

PROPER is a quick fix for names and titles typed in all caps or all lowercase. It capitalises any letter that follows a non-letter and lowercases the rest. That rule gives the right result for hyphenated and apostrophe names (“O'Neil”, “Mary-Jane”) but the wrong one for “2nd” (“2Nd”), “McDonald” (“Mcdonald”) and acronyms (“NASA” → “Nasa”). Check the results before overwriting the original data.

Airtable has no PROPER at all and can't loop over words in a formula, so multi-word title case needs a script or has to be done before import. Notion can do it by splitting the text into a list of words, capitalising each with map() and joining them back. That version only treats spaces as word breaks.

Frequently Asked Questions

How do I keep acronyms in capitals?
PROPER can't. Apply it, then put specific words back with SUBSTITUTE: =SUBSTITUTE(PROPER(A2), "Nasa", "NASA").

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