PROPER (Primitive Spread Function) capitalizes the first letter in each word of a text string.

SYNTAX:

PROPER(text)

REMARKS:

The PROPER function capitalizes letters that follow any character other than a letter, for example, a space. The PROPER function converts all other letters to lowercase letters.

The text argument can be a string, a formula that returns a string, or a reference to a cell containing a string. 

EXAMPLES:

PROPER(D2)
PROPER("INTRO to SPREAD") equals Intro To Spread
PROPER("Pam's date-nut bread") equals Pam'S Date-Nut Bread