PROPER


returns text with words in lowercase after a capitalised first letter.

Syntax:

PROPER(text)
returns text with the first letter of each word capitalised, and other letters in lower case. More specifically, the first letter and any letter that follows a non-letter are capitalised.

Example:

PROPER("gooD morNINg")
returns Good Morning.
PROPER("john o'connor")
returns John O'Connor.
PROPER("don't worry")
returns Don'T Worry. The T is capitalised as it follows a non-letter.
SUBSTITUTE(PROPER(SUBSTITUTE("don't worry","'","'x")),"'X","'")
returns Don't Worry.






 
Created with Zapof