Excel Tips and Tricks / Business Reporting Question: I usually export my inventory data into Excel for further analysis. However the products names appear in upper case when I do this. Is there a way of converting the product names to lowercase and then capitalizing each word – how do I do this in Excel?

Answer: By using the proper function

Why: To convert the text of data into proper case (Capitalize each word)

Applies To: Excel 2010, 2007, 2003, XP, 2000, 97

1. Given that you have the data below

 

2. Select cell E4 and type; =proper (D4)

3. Press Enter and copy the formula down

4. The result will be the screen shot below

 

The products names are now in proper case. This has been achieved by using one function and the products names are now formatted correctly.