Converting Text Cases in Excel
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.
