This function will function will capitalize the first letter of each word.

Syntax

PROPER(Text)

  • Text (required) – This is the text string which you want to capitalize the first letter of each word.

Example

In this example we capitalize the first letter of each word.

=PROPER(A2)
PROPER PROPER function