(string Text)
Capitalizes the first letter in a text string and any other letters in text that follow any
character other than a letter. Converts all other letters to lowercase letters.
Example: PROPER(this is a TITLE) is a proper case of first string (This Is A Title).
Text: Required. Text enclosed in quotation marks, a formula that returns text, or a reference
to a cell containing the text you want to partially capitalize.
Example
Proper case Danish Weekday names:
proper(tostring(&Date,"dddd","da-DK"))
Comments
Please sign in to leave a comment.