Difference between revisions of "Documentation/How Tos/Calc: PROPER function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
m |
||
Line 1: | Line 1: | ||
− | {{ | + | {{DISPLAYTITLE:PROPER function}} |
− | + | {{Documentation/CalcFunc TextTOC | |
− | + | |ShowPrevNext=block | |
− | + | |PrevPage=Documentation/How_Tos/Calc:_MID_function | |
− | | | + | |NextPage=Documentation/How_Tos/Calc:_REPLACE_function |
− | + | }}__NOTOC__ | |
− | | | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | }} | ||
== PROPER == | == PROPER == | ||
− | returns text with words in lowercase after a | + | returns text with words in lowercase after a capitalized first letter. |
=== Syntax: === | === Syntax: === | ||
<tt>'''PROPER(text)'''</tt> | <tt>'''PROPER(text)'''</tt> | ||
− | : returns <tt>'''text'''</tt> with the first letter of each word | + | : returns <tt>'''text'''</tt> with the first letter of each word capitalized, and other letters in lower case. More specifically, the first letter and any letter that follows a non-letter are capitalized. |
=== Example: === | === Example: === | ||
Line 50: | Line 19: | ||
: returns <tt>'''John O'Connor'''</tt>. | : returns <tt>'''John O'Connor'''</tt>. | ||
<tt>'''PROPER("don't worry")'''</tt> | <tt>'''PROPER("don't worry")'''</tt> | ||
− | : returns <tt>'''Don'T Worry'''</tt>. The '''T''' is | + | : returns <tt>'''Don'T Worry'''</tt>. The '''T''' is capitalized as it follows a non-letter. |
<tt>'''SUBSTITUTE(PROPER(SUBSTITUTE("don't worry";"'";"'x"));"'X";"'")'''</tt> | <tt>'''SUBSTITUTE(PROPER(SUBSTITUTE("don't worry";"'";"'x"));"'X";"'")'''</tt> | ||
: returns <tt>'''Don't Worry'''</tt>. | : returns <tt>'''Don't Worry'''</tt>. |
Latest revision as of 15:34, 2 February 2024
< {{#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 capitalized first letter.
Syntax:
PROPER(text)
- returns text with the first letter of each word capitalized, and other letters in lower case. More specifically, the first letter and any letter that follows a non-letter are capitalized.
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 capitalized 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
}}