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:

DOWNLOAD EXCEL WORKBOOK

 
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)

 

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

Proper

 

HELPFUL RESOURCE:

oztraining_728x90

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

RANDBETWEEN Function for Excel Dates What does it do? Generates random dates, in between a start date and an end date Formula breakdown: =RANDBETWEEN(bottom, top) What it means: =RANDBETWEEN(starting date for random date generation, end date for random date generation)   If you need to ...
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...
BETWEEN Formula in Excel There is no explicit Between formula in Excel, however we can come up with creative ways to create this functionality. Our goal is to evaluate if a given value is between a range, for example, is 6 between 1 and 10? We have three possible scenarios: numbers, dates, and text. ...
Remove Second Hyphen with Excel’s SUBSTITUTE... What does it do? Substitutes new_text for old_text in a text string. Formula breakdown: =SUBSTITUTE(text, old_text, new_text, ) What it means: =SUBSTITUTE(This cell, By this text character, To this text character, ) There are times where I needed to remove t...