The Excel PROPER function capitalizes the first letter of every word and lowercases the rest — the one-step fix for name lists typed in ALL CAPS or all lowercase. It works in every version of Excel. Its siblings are UPPER and LOWER, and its famous blind spot is names like McDonald, which it returns as “Mcdonald”.
=PROPER("ANA TORRES") returns Ana Torres. Every letter that follows a non-letter character gets capitalized; everything else is lowercased.
Syntax
| Argument | Description | |
|---|---|---|
text | Required | The text to convert — a string in quotes, a cell reference, or another formula’s result. |
How it decides what’s a “word”: PROPER capitalizes any letter that follows a character that isn’t a letter — a space, hyphen, apostrophe, digit, or the start of the string. That’s why mary-jane becomes Mary-Jane and o’brien becomes O’Brien. Available in every version of Excel, Excel for the web, and Google Sheets.
Fix a name list
A column of names arrives half in capitals, half lowercase. One helper column fixes nearly all of them:
| A | B | |
|---|---|---|
| 1 | Raw entry | =PROPER(A2) |
| 2 | ANA TORRES | Ana Torres |
| 3 | james o’brien | James O’Brien |
| 4 | mary-jane fox | Mary-Jane Fox |
| 5 | SEAN MCDONALD | Sean Mcdonald ← gotcha |
Note row 5: PROPER lowercases every letter that isn’t at the start of a word, so McDonald becomes Mcdonald — more on that below. To replace the originals, copy the helper column, then Paste Special › Values. In Excel 365 one formula converts the whole column:
Try it: interactive PROPER demo
Type a name and watch PROPER convert it — try SEAN MCDONALD or james o’brien to see the word-boundary rules in action.
The McDonald problem (and other exceptions)
PROPER applies one mechanical rule with no dictionary behind it, so several name patterns come out wrong:
| Input | PROPER returns | You wanted |
|---|---|---|
MCDONALD | Mcdonald | McDonald |
VAN DER BERG | Van Der Berg | van der Berg |
JOHN SMITH III | John Smith Iii | John Smith III |
IBM | Ibm | IBM |
3RD QUARTER | 3Rd Quarter | 3rd quarter |
For a handful of known offenders, patch them afterwards with SUBSTITUTE:
And the all-purpose cleanup combo pairs PROPER with TRIM to kill stray spaces in the same pass:
Errors & common pitfalls
Pitfall: PROPER lowercases what it doesn’t capitalize. It isn’t just “capitalize first letters” — everything else is forced lowercase. Acronyms (IBM → Ibm), Roman numerals (III → Iii), and mid-word capitals (McDonald → Mcdonald) all get flattened. Review name data before pasting results over the source.
Pitfall: digits count as word boundaries. The letter after a digit gets capitalized: =PROPER("2nd floor") returns 2Nd Floor, and sku1042w becomes Sku1042W. Don’t run PROPER on product codes.
Pitfall: numbers come back as text. Like all text functions, PROPER returns text. Feed it the number 1042 and you get the text “1042”, invisible to SUM. Wrap in VALUE if math must follow.
#NAME? — typo or missing quotes. PROPER exists everywhere, so #NAME? almost always means a misspelled function name or a literal string missing its quotes: =PROPER(ana torres) instead of =PROPER("ana torres").
Practice workbook
Frequently asked questions
Why does PROPER turn McDonald into Mcdonald?
How do I apply PROPER to a whole column?
=PROPER(A2:A500). In older versions, enter =PROPER(A2) and double-click the fill handle. Then copy and Paste Special › Values if you want to replace the originals.Does PROPER capitalize after hyphens and apostrophes?
Is there a real Title Case function that skips small words like 'of' and 'the'?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class