PROPER

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

Syntax

=PROPER(text)

Parameters

• text: The text whose first letter of each word you want to capitalize

Examples

=PROPER("hello world") // Returns "Hello World"
=PROPER("JOHN DOE") // Returns "John Doe"
=PROPER("first-name") // Returns "First-Name"