PROPER function
PROPER capitalizes the first letter of every word in text and lowercases the rest. It is good for tidying names, though names like McDonald need a manual fix.
Example
Read it as a sentence: capitalize the first letter of each word in john smith, which gives John Smith.
A
B
C
D
1
John Smith
2
3
Syntax
PROPER(text)
-
text(required) - The text to convert.
Returns: The text with each word capitalised.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=PROPER("hello WORLD") | Hello World | Mixed |
=PROPER("o'neil 2nd-place") | O'Neil 2Nd-Place | Apostrophe, digits, hyphen |
=PROPER("ab1cd") | Ab1Cd | Letter after digit |
=PROPER(123) | 123 | Number |
=PROPER(Data!F5) | #DIV/0! | Error |
The Data sheet these formulas read
A cell that starts with = holds that formula.
F
1
2
'123
3
2024-02-29
4
TRUE
5
=1/0
Data
Watch out for
- A letter after an apostrophe is capitalised, so "it's" becomes "It'S".
- Acronyms get lowercased.
Where it works
- Excel
- PROPER is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Text functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .