PROPER function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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.
See Also
