[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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 |
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:
PROPER("12aBC d123aD#$%sd^") results in 12Abc D123Ad#$%Sd^
PROPER(A10) results in 12Abc D123Ad#$%Sd^, when A10 contains 12aBC d123aD#$%sd^
end example]