Text
Modern
PROPER
Capitalizes the first letter of each word in a text string and lowercases the rest.
Available in All versions
Syntax
PROPER(text)What it returns
The text in title case — each word capitalized.
Arguments
| Argument | Required | Description |
|---|---|---|
text |
Yes | The text to convert to title case. |
Example
Before
john smith
After
John Smith
PROPER capitalises the first letter of each word.
=PROPER(A2)Important to know
Capitalizes after any non-letter — "o'brien" becomes "O'Brien" and "mcdonald" becomes "Mcdonald" (it can't know real name casing).
Affects letters only; numbers and symbols are unchanged.