The PROPER function returns a string value where the first letter of each word is uppercase and all remaining characters are lowercase, regardless of the case of the characters in the specified string value.
PROPER(source-string)
source-string: Any value. However, only string values are affected by the function.
Notes
Any character following a non-alphabetic character, except apostrophe (‘), is treated as the first letter in a word. So, for example, any letter following a hyphen is capitalized.
Examples |
|---|
=PROPER(“lorem ipsum”) returns “Lorem Ipsum”. =PROPER(“lorem’s ip-sum”) returns “Lorem’s Ip-Sum”. =PROPER(“1a23 b456”) returns “1A23 B456”. =PROPER(60) returns “60”. |