The function PROPER converts a text string to the proper case, First letter to upper case and all others to lower case.
Syntax:
=Proper(text string)
Text string: is the text string or a reference to a cell containing a text string to properly capitalize.