PROPER

Turns the first letter of each word into uppercase (capital) letter and any other into lowercase

Usage

PROPER(text)

Parameters

text	(Required) The text string in which to capitalize the first letter of each word.

Examples

Example	Result
PROPER(“anna logwatch”)	“Anna Logwatch”
PROPER(“aNna LOGwaTch”)	“Anna Logwatch”
PROPER(“123 abc”)	“123 Abc”
PROPER(“aLL cAPS”)	“All Caps”
PROPER(“ leading spaces”)	” Leading Spaces”
PROPER(“Trailing spaces “)	“Trailing Spaces “

More information

Any letter following a non-letter character is capitalized.

If you use a variable, its value will not be modified. The PROPER function will return the transformed text, but if you use the variable elsewhere, it will have its original text.

PROPER

Usage

Parameters

Examples

More information

See also