PROPER
Description
PROPER returns the specified string in proper-case format.
Syntax
PROPER ( text )
|
Parameter |
Description |
|
text |
Any string. |
Remarks
In proper-case format, the first alphabetic character in a word is capitalized. If an alphabetic character follows a number, punctuation mark, or space, it is capitalized. All other alphabetic characters are lowercase. Numbers are not changed by PROPER.
Examples
This function returns 3Rd Quarter:
=PROPER("3rd Quarter")
This function returns John Doe:
=PROPER("JOHN DOE")
Also, see