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
< {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
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.