PROPER function
PROPER(Text) PROPER(Text)
Text
Text or { Text }
The text string to convert.
Returns
Text or { Text }
The converted text string.
Returns a version of the given text string using "proper" capitalization. PROPER("given naMe 2a")PROPER("given naMe 2a") returns "Given Name 2A".
Specifically, the first letter of each word is capitalized, as well as any other letter that follows a character which is not a letter. All other letters are made lower-case.
Example
PROPER("given naMe
2a")PROPER("given naMe
2a")
Returns "Given Name 2A".