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.
Add the following code to the first cell, again in my case it’s A2, that you want to change the text of:
From there you can just copy and paste the code down the row and all your caps will become proper text.
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