Documentation/How Tos/Calc: PROPER function
From Apache OpenOffice Wiki
CALC FUNCTIONS
- Text Functions
- BaseCharCleanCodeConcatenateDollarExactFindFixedLeftLenLowerMidProperReplaceReptRightSearchSubstituteTText
Contents
PROPER
returns text with words in lowercase after a capitalised first letter.
Syntax:
PROPER(text)
- returns text with the first letter of each word capitalised, and other letters in lower case. More specifically, the first letter and any letter that follows a non-letter are capitalised.
Example:
PROPER("gooD morNINg")
- returns Good Morning.
-