Related Functions:

The PROPER function capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.

Syntax

=PROPER(text)

Arguments

Argument Description
text The string argument whose first character in each word will be converted to uppercase and all remaining characters converted to lowercase.

Note: Letters following numbers or other punctuation are converted to upper case by the PROPER function. This may be in places that you might not expect.

Examples

  A B C D
1 Text Formula Result Notes
2 to bE or NoT To be =PROPER(A2) To Be Or Not To Be  
3 zachary       taylor =PROPER(A3) Zachary     Taylor Spaces are not affected
4 san diego, CA =PROPER(A4) San Diego, Ca Existing capitalization may be affected
5 betty’s basic math =PROPER(A5) Betty’S Basic Math Letters following punctuation are converted to upper case
6 10th edition =PROPER(A6) 10Th Edition Letters following numbers are converted to upper case

Usage note: When text data is imported or copied into an Excel spreadsheet sometimes the words have incorrect capitalization.

  • If you want to converts all uppercase letters in a text string to lowercase, please use LOWER function.
  • If you want to converts all lowercase letters in a text string to uppercase, please use UPPER function.