Description
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")
See also