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:

=PROPER(text)

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:

## =PROPER

STEP 2:Â The ProperÂ arguments:

## text

Which text do we want to change?

Reference the cell that contains the text string:

## =PROPER(C10)

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:

Click here to access these FREE Excel courses!

If you like this Excel tip, please share it

email

Pinterest