This function capitalizes the first letter in each word of a text string.
PROPER(text)
The text argument can be a string, a formula that returns a string, or a reference to a cell containing a string.
This function capitalizes letters that follow any character other than a letter, for example, a space. This function converts all other letters to lowercase letters.
Accepts string data. Returns string data.
PROPER(D2)
PROPER(""INTRO to SPREAD"") gives the result Intro To Spread
PROPER(""Tom's one-time order"") gives the result Tom’S One-Time Order