PROPER

Capitalizes the first letter of each sentence in a text string. Periods determine a sentence.

Syntax

PROPER(text-expression)

Arguments

text-expression

Text or cell reference to evaluate.

Example

PROPER("the developers are coding today. fantastic!") returns "The developers are coding today. Fantastic!"