Category: Text function

This function converts text to the proper case (or "title case"), i.e. the first letter of each word becomes uppercase, the remaining letters become lowercase.

Return value type: Text

This function has no effect on numbers, symbols, or non-printing characters.

Note that words that appear in all uppercase letters retain their case. To convert these strings to proper case, first convert them to lowercase. See examples below.

proper('hey Jude') //Returns 'Hey Jude'

proper('back to the USSR') //Returns 'Back To The USSR"  (All uppercase words remain uppercase)

proper(lower('UPPER CASE TEXT')) //Returns 'Upper Case Text'  (Convert uppercase words to lowercase first)

• Lower(text)
• Upper(text)