What it does
PROPER splits the text into words and capitalises the first letter of each one, lowering the rest. It treats every character that is not a letter as a word boundary, not just spaces: the letter after a hyphen, a slash or an apostrophe is capitalised too. That is why "o'neill" becomes "O'Neill", but "kate's shop" becomes "Kate'S Shop".
Abbreviations are treated as ordinary words, so "VAT" becomes "Vat" and "UK" becomes "Uk". Fix such words afterwards with SUBSTITUTE. To make all letters upper or lower case, use UPPER or LOWER.
PROPER changes only letters. Extra spaces stay where they are, so names pasted from other systems are usually cleaned with TRIM in the same formula: =PROPER(TRIM(A2)).
Syntax
=PROPER(text)=YAZIM.DÜZENİ(metin)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
text | Required | The text, or cell, to tidy. Characters that are not letters (spaces, hyphens, slashes, apostrophes) count as word boundaries; digits are unchanged. |
Examples
1Fix names typed in mixed case
Some names were typed in lower case, others in capitals. PROPER capitalises the first letter of each word and lowers the rest.
=PROPER(A2)| A | B | |
|---|---|---|
| 1 | Name as Typed | Clean Name |
| 2 | emma brown | Emma Brown |
| 3 | LUCAS GRAY | Lucas Gray |
| 4 | ava thompson | Ava Thompson |
| 5 | noah CLARK | Noah Clark |
| 6 | olivia hughes | Olivia Hughes |
- B2 (filled down to B6)
=PROPER(A2)
B3 shows Lucas Gray and B5 shows Noah Clark.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Trim and tidy district and city names
The address column also has extra spaces. TRIM cleans the spaces first and PROPER then fixes the letters; the letter after the slash is capitalised too.
=PROPER(TRIM(A2))| A | B | |
|---|---|---|
| 1 | Address as Typed | Clean Address |
| 2 | camden / london | Camden / London |
| 3 | ROUNDHAY / LEEDS | Roundhay / Leeds |
| 4 | salford / manchester | Salford / Manchester |
| 5 | southwark / london | Southwark / London |
- B2 (filled down to B5)
=PROPER(TRIM(A2))
B2 shows Camden / London and B3 shows Roundhay / Leeds; double spaces inside are reduced to one as well.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- Capital after an apostrophe
Cause: The apostrophe counts as a word boundary, so the letter after it is capitalised: "kate's" → "Kate'S".
Fix: Fix common endings afterwards:
=SUBSTITUTE(PROPER(A2),"'S ","'s "), or review those rows by hand.- Broken abbreviation
Cause: Abbreviations such as "VAT" or "LTD" are treated as words and become "Vat" and "Ltd".
Fix: Restore them with SUBSTITUTE:
=SUBSTITUTE(PROPER(A2),"Vat","VAT").- Extra spaces remain
Cause: PROPER only changes letters; extra spaces between words stay.
Fix: Trim first:
=PROPER(TRIM(A2)).
Good to know
- To make the corrected names permanent, copy the results and paste them over the source column with Paste Values.
- To capitalise only the first letter of the whole text, use
=UPPER(LEFT(A2,1))&MID(A2,2,LEN(A2))instead of PROPER.
In Nexell
Get Nexell to do it from a sentence
Tidy the Full Name column so each word starts with a capital letter, and remove extra spaces
Convert to tableBring your list into the tool and type this. Nexell writes the corrected names into a new column and shows them in a preview first; the source column stays as it is.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
How do I capitalise only the first letter in Excel?
PROPER capitalises the first letter of every word. To capitalise just the first letter of the text and leave the rest alone, use =UPPER(LEFT(A2,1))&MID(A2,2,LEN(A2)).
Why does PROPER give "Mcdonald" instead of "McDonald"?
PROPER only knows word boundaries, not name rules, so it lowers every letter after the first. Names with an inner capital (McDonald, MacLeod) need a manual fix or a SUBSTITUTE afterwards.