This function capitalizes the first letter in each word of a text string.

Syntax

PROPER(text)

Arguments

The text argument can be a string, a formula that returns a string, or a reference to a cell containing a string.

Remarks

This function capitalizes letters that follow any character other than a letter, for example, a space. This function converts all other letters to lowercase letters.

Data Types

Accepts string data. Returns string data.

Examples

Version Available

This function is available in product version 1.0 or later.

See Also

CHAR | UPPER | Text Functions