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

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.

• LOWER
• UPPER

• Text functions

• Functions listed alphabetically
• Functions listed by category