Difference between revisions of "Documentation/How Tos/Calc: PROPER function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→Example:: examples to show apostrophe handling) |
|||
| Line 52: | Line 52: | ||
: returns <tt>'''Don't Worry'''</tt>. | : returns <tt>'''Don't Worry'''</tt>. | ||
| − | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: LOWER function|LOWER]] | * [[Documentation/How_Tos/Calc: LOWER function|LOWER]] | ||
* [[Documentation/How_Tos/Calc: UPPER function|UPPER]] | * [[Documentation/How_Tos/Calc: UPPER function|UPPER]] | ||
Revision as of 07:24, 17 July 2018
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.
PROPER("john o'connor")
- returns John O'Connor.
PROPER("don't worry")
- returns Don'T Worry. The T is capitalised as it follows a non-letter.
SUBSTITUTE(PROPER(SUBSTITUTE("don't worry";"'";"'x"));"'X";"'")
- returns Don't Worry.
See Also
