PROPER

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

Syntax

PROPER(text)

Arguments

[Required] 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.

Examples

PROPER(D2)

PROPER("INTRO to SPREAD") gives the result Intro To Spread

PROPER("Tom's one-time order") gives the result Tom's one-time order