PROPER(text)

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:

Other text functions