PROPER
Syntax:
PROPER ( string )
Description: Makes a lowercase version of string except that the first letter in string and any other letters in string that immediately follow a character that is not a letter, are converted to uppercase.
Arguments:
Name |
Type |
Description |
|---|---|---|
string |
text, reference |
Designates the string to be converted. |
Return Type and Value: text – A version of string such that the first letter in string and any other letters in string that immediately follow a character that is not a letter, are converted to uppercase. All other letters are converted to lowercase, and all other non-letters are unchanged.
example: