Difference between revisions of "Documentation/How Tos/Calc: PROPER function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
(→Syntax:: more detail) |
||
| Line 40: | Line 40: | ||
=== Syntax: === | === Syntax: === | ||
<tt>'''PROPER(text)'''</tt> | <tt>'''PROPER(text)'''</tt> | ||
| − | : returns <tt>'''text'''</tt> with the first | + | : returns <tt>'''text'''</tt> 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: === | === Example: === | ||
Revision as of 23:05, 7 May 2014
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.
-
