PROPER
Text

Capitalizes the first letter in each word of a text value

Syntax:

=PROPER(text)

Example:

=PROPER("john smith")