Convert All Caps Text to Proper Case in Excel

Lately I have been downloading a lot of datafeeds where all the titles of the products are in all CAPS, why do merchants do this?

So how do you change all caps to normal fonts without using search and replace?

The easiest way to do this is first create a new column in Excel*

My example is having my data beginning in Cell A2, since I have header text.

1stshot

Add the following code to the first cell, again in my case it’s A2, that you want to change the text of:

=PROPER(A2)

proper

From there you can just copy and paste the code down the row and all your caps will become proper text.

done2

Now you have a proper formatted text in Excel to go ahead and move on to your next project. Please let me know if you have any questions.

*I am using Office 2007

Why another blog about forums? Great question, we are just a couple of forum owners who have built ours forums from the ground-up. We just wanted a blog for real life forum owners, with real life experiences.

View all contributions by

Get more updates by subscribing

Leave a Comment