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".