PROPER in Excel: Syntax, Examples and Errors
Updated 2026-10-14 · Free · Works in Excel & Google Sheets
Syntax
=PROPER(text)Quick answer
PROPER capitalizes the first letter of every word and lowercases the rest: =PROPER(A2) turns "jane doe" into "Jane Doe". It follows one mechanical rule — anything that is not a letter starts a new word — so "McDonald" flattens to "Mcdonald", "USA" to "Usa", and the result is always text.
Syntax
=PROPER(text)| Argument | What it means |
|---|---|
| text | The cell or literal to convert to Proper case — first letter of every word capitalized, everything else lowercased. Required — and the only argument. |
With a single argument there is nothing to separate, so the semicolon question never comes up: =PROPER(A2) looks identical in every locale.
PROPER works by position, not by meaning: every letter that follows a non-letter (space, digit, punctuation) becomes a capital, everything else goes lowercase. That is why "jane doe" becomes "Jane Doe", why "o’brien" becomes "O’Brien" — and why "McDonald" becomes "Mcdonald". Accented letters follow the same rule (é → É) in current Excel versions.
Basic examples
=PROPER(A2)The display-column workhorse: "jane doe" reads "Jane Doe", addresses come out as "123 Main Street", and imported name lists stop looking typed with Caps Lock — anywhere a human reads the result.
=PROPER(TRIM(A2))Clean-then-capitalize: TRIM strips leading, trailing and duplicated spaces first, so " jane doe " comes out as "Jane Doe" instead of " Jane Doe ". The two nest constantly on imported data.
=SUBSTITUTE(PROPER(A2), "Mcdonald", "McDonald")PROPER cannot know that McDonald, MacBook or iPhone keep inner capitals — it flattens them to Mcdonald, Macbook, Iphone. The standard remedy is a short patch list of SUBSTITUTE fixes for the names you actually meet; "USA" needs the same treatment to come back as "USA" instead of "Usa".
=EXACT(A2, PROPER(A2))The Proper-case check: TRUE only when the cell is already in Proper case. Plain = cannot do this — Excel treats "jane doe" = "Jane Doe" as equal — so EXACT is the only comparison that respects letter case.
=IF(EXACT(A2, PROPER(A2)), "OK", "Fix")Turns the check into a flag column: rows still needing normalization read "Fix", which is exactly what you want to see before an import into a case-sensitive system.
PROPER stringifies numbers: PROPER(12345) returns the text "12345" that no longer sums, and a date comes back as its serial number ("45658"), not a date. Keep numeric and date columns out of PROPER, or convert digits back with VALUE.
Common errors and how to fix them
| Symptom | Most common cause | Fix |
|---|---|---|
| The result cannot be summed or charted | PROPER converts numbers to text — PROPER(12345) is the label "12345", not the value. | Run PROPER only on genuine text columns. If digits must pass through, convert back with =VALUE(PROPER(A2)). |
| A date turns into something like 45658 | Dates are serial numbers under the hood; PROPER stringifies the serial, not the displayed date. | Exclude date columns from the conversion, or format the result as a date afterwards. |
| "McDonald" comes out "Mcdonald", "USA" as "Usa" | PROPER applies one mechanical rule and has no dictionary of names or acronyms. | Patch the exceptions you actually meet: =SUBSTITUTE(PROPER(A2), "Mcdonald", "McDonald") — or fix a short list by hand. |
| "2nd Avenue" becomes "2Nd Avenue" | Digits count as word starters: every letter after a number is treated as a first letter and capitalized. | No formula fully undoes it — edit such rows by hand, or clean the digits out of the column first. |
| Blank rows stop being blank | PROPER of an empty cell returns "" — empty text, which no longer counts as blank for ISBLANK. | Guard it: =IF(A2="", "", PROPER(A2)) keeps genuinely empty rows empty. |
Not an error, but worth knowing: PROPER capitalizes after every non-letter. That is the same rule that gives you "O’Brien" for free from "o’brien" — and "2Nd" for free from "2nd".
PROPER vs. UPPER and LOWER
| PROPER | UPPER | LOWER | |
|---|---|---|---|
| Converts to | First Letter Of Each Word | ALL CAPITAL LETTERS | all lowercase |
| "jane doe" becomes | "Jane Doe" | "JANE DOE" | "jane doe" |
| Typical job | Display names, addresses, titles | Codes, IDs, country and state abbreviations, matching keys | Email addresses, usernames, lowercase system fields |
| Known quirk | "McDonald" flattens to "Mcdonald", "USA" to "Usa" | Numbers become text | Same |
All three take exactly one text argument and always return text. Choose by audience: human eyes get PROPER — with manual fixes for the names it flattens — while machines and joins prefer the uniform UPPER or LOWER.
PROPER vs. Flash Fill
| PROPER formula | Flash Fill (Ctrl+E) | |
|---|---|---|
| Output | A live formula in a helper column; recalculates when the source changes | Static values, written once; new rows need a refill |
| Precision | Deterministic — every row, every time | Pattern-guessed — spot-check the result column |
| Best for | Repeating imports and reports that must stay current | One-time cleanups of a finished table |
| Available in | Every Excel version and Google Sheets | Excel 2013 and later; Sheets answers with Smart Fill |
Choose by lifespan: PROPER formulas for data that keeps arriving, Flash Fill for a one-time reshaping you will paste over. If you keep the formula route, paste values back once the column is final.
PROPER in Google Sheets
- Same name, same single argument — every formula above pastes into Sheets unchanged.
- The = ignores case / EXACT distinction behaves identically, so the Proper-case check transfers as-is.
- Smart Fill (the Sheets answer to Flash Fill) also guesses a capitalized pattern — same caveat: it writes static values, not live formulas.
- Accented capitals (É, Ñ, Ç) come out correctly in both products; locale quirks only affect very old Excel versions.
Limitations and pro tips
- One job per call: PROPER cannot force all caps (UPPER), all lowercase (LOWER) or remove spaces (TRIM) — stack them: =PROPER(TRIM(A2)).
- No dictionary: keep a short SUBSTITUTE patch list for the names and acronyms your data actually contains — McDonald, iPhone, USA — instead of trusting the formula to know them.
- Digits start new words: "2nd" → "2Nd", "3rd" → "3Rd" — check any row that mixes letters with numbers.
- Apostrophes work in your favor: "o’brien" comes out "O’Brien" with no extra work.
- Blank cells become "" under PROPER — guard with IF(A2="", "", PROPER(A2)) when empties must stay empty.
- Paste values back: Copy the helper column → Paste Special → Values → delete the helper, so the table survives source-column cleanup.
Think of PROPER as the display window of a cleaning line: TRIM the padding, PROPER the letters for human readers, patch the exceptions, then paste values back. Machine consumers should read the UPPER or LOWER column instead — one canonical form per audience keeps every join safe.
Related Tools
Related Functions
Frequently Asked Questions
What does the PROPER function do in Excel?
It capitalizes the first letter of every word and lowercases the rest: =PROPER(A2) turns "jane doe" into "Jane Doe". The rule is mechanical — spaces, digits and punctuation all start a new word — and the result is always text.
How do I capitalize an entire column?
Add a helper column with =PROPER(A2), fill it down, then Copy → Paste Special → Values over the original and delete the helper. Every row follows the same rule, which makes it safer than retyping or Find and Replace.
Why does PROPER turn my numbers into text?
PROPER is a text function: it receives 12345 and returns the label "12345", which no longer sums or charts. Dates come back as serial numbers ("45658"). Keep numeric and date columns out of PROPER, or convert digits back with VALUE.
Why does PROPER turn McDonald into Mcdonald?
PROPER knows one rule — capitalize after any non-letter — and has no dictionary of names. Flattening is the price; patch the names you meet with =SUBSTITUTE(PROPER(A2), "Mcdonald", "McDonald") or fix them by hand.
Why does "2nd" become "2Nd"?
Because digits count as word starters: the letter after a number is treated as a first letter and capitalized. There is no built-in switch to turn this off — edit such rows manually or split the digits out first.
What is the difference between PROPER, UPPER and LOWER?
PROPER capitalizes each word for human reading; UPPER makes everything capitals and LOWER everything lowercase for machines. Codes and joins take UPPER or LOWER, display columns take PROPER — remembering that PROPER flattens "McDonald" and "USA".
Does PROPER work in Google Sheets?
Yes — same name, same single argument, same EXACT-based case checks. Sheets also offers Smart Fill as the Flash Fill alternative, with the same caveat that it writes static values instead of live formulas.
Ready to try it on your own file?
Open Change Case in Excel — It's Free