The PROPER function capitalizes the first letter in each word of a text value. A word is any continuous string of letters that follows a character other than a letter. Letters that are not capitalized by PROPER are reduced to lower case.
For example:
PROPER("no smoking") returns "No Smoking"
PROPER("NO SMOKING") returns "No Smoking"
PROPER("Leonardo’s masterPiece") returns "Leonardo’S Masterpiece"
See also: