PROPER

Syntax

PROPER (character_expression)

Description

Converts to uppercase the first letter and any letters in text that follow a space or a special character. Converts all other letters to lowercase letters.

Arguments

character_expression

Text enclosed in quotation marks or a formula that returns text.

Returns

The character_expression in String format.

Examples

PROPER ("once upon a time")

Returns: Once Upon A Time

PROPER ("it's about time")