PROPER

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

PROPER( Text text ) → Text

Parameters

text

Required. The text to capitalize.

Example

Formula

=PROPER("this is a TEXT")

See Also

Function Reference
LOWER Function
UPPER Function