What does it do?

Capitalizes the first letter in a text string and any other letters in the text that follow a space. Converts all other letters to lowercase letters.

Formula breakdown:


What it means:

=PROPER(this text cell)

There are times when you will need to only CAPITALIZE the first letter in each word.  The most common scenario would be when you receive data with employee names, countries or cities that are all in lower or uppercase.

The PROPER formula in Excel can help you format the text very very easily…goodbye manual adjustments!

In our example below, we have a list of names in capital letters.  However we want to show the capital letters only on the first letter of each word.

I explain how you can do this and please go to the bottom of the page to see the animated gif tutorial:


STEP 1: We need to enter the Proper function next to the cell that we want to clean the data from:



STEP 2: The Proper arguments:


Which text do we want to change?

Reference the cell that contains the text string:



Proper 01


STEP 3: Do the same for the rest of the cells by dragging the PROPER formula all the way down using the left mouse button.

Note that all of the names are now properly formatted:

Proper 02




How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Extracting Data with Excel’s RIGHT Formula What does it do? It returns the last character or characters in a text string, based on the number of characters you specify. Formula breakdown: =RIGHT(text, ) What it means: =RIGHT(look in this cell, extract X characters) There are times when you will need ...
Cleaning Data with Excel’s CLEAN Formula   What does it do? Removes all nonprintable characters from text Formula breakdown: =CLEAN(text) What it means: =CLEAN(this dirty text cell) There are times when imported text from other applications contain characters that are unprintable. The CLEAN...
Cleaning Data with Excel’s TRIM Formula What does it do? Removes unneeded spaces in your text, except single spaces in between words Formula breakdown: =TRIM(text) What it means: =TRIM(text that you want extra spaces to be removed) In the quest for cleaner data, one of the common scenarios is remo...
Division Formula in Excel What does it do? Divides two numbers Formula breakdown: =number1 / number2 What it means: =the number being divided / the number you are dividing by In Excel dividing numbers together is really easy! The Division Formula is done through the use of the div...