PROPER
Capitalizes the first letter in each word of a text value.
TextText Processing
What it does
Capitalizes the first letter of each word in a string.
Syntax
PROPER(text)
Arguments
text(text) — Text to convert.
Examples
Title Case
Convert 'john doe'.
FORMULA
=PROPER("john doe")RESULT
John Doe
SAMPLE DATA
| A | |
|---|---|
| 1 | Text |
| 2 | john doe |