How to Proper-Case Names in Excel
A column of names in ALL CAPS or all lowercase looks unprofessional — but Excel's PROPER() gets real names wrong. It turns MCDONALD into "Mcdonald" and doesn't know that van should stay lowercase. Here's how to fix names properly.
Last updated: August 2026
| As typed | Proper-cased | |
|---|---|---|
| RONALD MCDONALD | → | Ronald McDonald |
| sean o'brien | → | Sean O'Brien |
| ludwig VAN beethoven | → | Ludwig van Beethoven |
Method 1 — the PROPER function
- In a helper column, enter
=PROPER(A2)and fill down. - Copy the column and Paste Special > Values back over the names.
- Hand-fix the names PROPER broke: McDonald, MacArthur, O'Brien, van der Berg, III…
PROPER only capitalizes the first letter of each word. It has no idea about the capital inside Mc/Mac names, hyphenated surnames, generational suffixes, or particles that belong in lowercase — so a real name list always needs manual cleanup afterward.
Method 2 — a giant nested formula
You can bolt SUBSTITUTE calls onto PROPER to patch the common cases — =SUBSTITUTE(PROPER(A2),"Mc","Mc") and friends — but it grows unreadable fast and still can't tell "Mack" (a name) from "MacArthur" (Mac + capital). It's the wrong tool for the job.
The 1-click way — Tellsheet
Smart Name Case capitalizes names the way a human would. It handles Mc and Mac prefixes (McDonald, MacArthur), apostrophes (O'Brien, D'Angelo), hyphens (Smith-Jones), generational suffixes (Jr, Sr), Roman numerals (Henry VIII), and lowercase name particles (van, von, de, del, di) that stay lowercase mid-name but capitalize when they lead. Previews first and is revertable. Pairs with Change Case and Split Names.
Frequently asked questions
How do I capitalize names correctly in Excel?
=PROPER(A2) for simple names, but it mis-cases McDonald and van Gogh. Tellsheet's Smart Name Case applies the real rules in one click.
Why does PROPER get McDonald wrong?
PROPER only capitalizes the first letter of each word, so it can't produce the internal capital in Mc/Mac names.
How do I keep 'van' and 'de' lowercase?
Smart Name Case keeps those particles lowercase in the middle of a name and capitalizes them when they lead — automatically.
Does it handle Jr, Sr and Roman numerals?
Yes — Jr/Sr are Title-cased and Roman numerals (II, III, VIII) are uppercased.
Related Excel guides
Fix name capitalization in one click
Smart Name Case handles McDonald, O'Brien, van Gogh, and Smith-Jones — right inside Excel.
Get Tellsheet free See pricing