Capitalizes the first letter in the specified text and any other letters that follow a character other than a letter. Converts all other letters to lowercase letters.
PROPER( Text text ) → Text
=PROPER("this is a TEXT")
Function ReferenceLOWER FunctionUPPER Function