Capitalizes the first letter in the specified text and any other letters that follow a character other than a letter. Converts all other letters to lowercase letters.

Syntax  Copy Code
PROPER( Text text ) → Text

Parameters

text

Required. The text to capitalize.

Example

Formula  Copy Code
=PROPER("this is a TEXT")

See Also

Function Reference
LOWER Function
UPPER Function