PROPER

See also A-Z Spreadsheet Function List

Description Returns the specified string in proper-case format.

Syntax PROPER(text)

text is 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.

See Also LOWER and UPPER functions

Examples PROPER(“3rd Quarter”) returns “3Rd Quarter”

         PROPER(“JOHN DOE”) returns “John Doe”