Difference between revisions of "Documentation/How Tos/Calc: PROPER function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
Line 31: Line 31:
 
* [[Documentation/How_Tos/Calc:_TEXT_function|<div style="font-size: 120%;">Text]]
 
* [[Documentation/How_Tos/Calc:_TEXT_function|<div style="font-size: 120%;">Text]]
 
* [[Documentation/How_Tos/Calc:_TRIM_function|<div style="font-size: 120%;">Trim]]
 
* [[Documentation/How_Tos/Calc:_TRIM_function|<div style="font-size: 120%;">Trim]]
 +
* [[Documentation/How_Tos/Calc:_UNICHAR_function|<div style="font-size: 120%;">Unichar]]
 +
* [[Documentation/How_Tos/Calc:_UNICODE_function|<div style="font-size: 120%;">Unicode]]
 
* [[Documentation/How_Tos/Calc:_UPPER_function|<div style="font-size: 120%;">Upper]]
 
* [[Documentation/How_Tos/Calc:_UPPER_function|<div style="font-size: 120%;">Upper]]
 
* [[Documentation/How_Tos/Calc:_VALUE_function|<div style="font-size: 120%;">Value]]
 
* [[Documentation/How_Tos/Calc:_VALUE_function|<div style="font-size: 120%;">Value]]

Revision as of 11:28, 29 January 2024


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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_PROPER_function&oldid=259515"
Views
Personal tools
Navigation
Tools