PROPERCASE

Use PROPERCASE to convert the first alphabetic character in each word to uppercase and all remaining characters to lowercase.

Syntax:
PROPERCASE (single-text-item-expression)
Meaning:
PROPERCASE (text_item_to_convert)
Returns:
A single text item

The PROPERCASE function views the text string as containing a series of "words" where the delimiter between words is the space character. For each "word" in text_item_to_convert, PROPERCASE converts the first alphabetic character (for example, A-Z and a-z) found to uppercase and all other characters are converted to lowercase.

Example

PROPERCASE ("sallY jo BRADLEY")

Returns: Sally Jo Bradley

Related functions

  • ISALPHA
  • ISLOWER
  • ISUPPER
  • LOWERCASE
  • UPPERCASE

Feedback