Documentation/How Tos/Calc: PROPER function
From Apache OpenOffice Wiki
< Documentation | How Tos
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.
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.
{{#switch:EN
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}
