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
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | PROPER(text) |
| Google Sheets | ✔ Built in | PROPER(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 | ≈ Workaround | split(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”. |
| 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(" ") | |
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 |
|---|---|---|---|
=PROPER("ada LOVELACE") | Ada Lovelace | ||
=PROPER("mary-jane o'neil") | Mary-Jane O'Neil | Any non-letter starts a new word. | |
=PROPER("2nd floor") | 2Nd Floor | Digits count as non-letters too. | |
=PROPER("mcdonald") | Mcdonald | PROPER 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").