Erasing a few charachters from many different cells

[slaneues]

Hello,

I am trying to write a loop that will recognize a date (as opposed to a word) and will then go into the cell and erase the last few charachters.

The problem I am trying to solve is that I am getting a bad data feed. I only care about the month and year that something takes place, however, when I export the data from the vendor into Excel, October 2012 comes out as 8/12/2012, April 2013 comes out as 4/13/2012 and Dec 2014 is 12/14/2012. In other words, I want to go into each of these cells (bot only if they are dates, some of the cells are text like "total"), erase "/2012" from each of them and then format each as a text so they are in mm/yy format.

Any ideas?

Thanks in advance for your help.

Shannon

[slaneues]

Oops. I meant that October 2012 would be 10/12/2012

[jeffreybrown]

Hi Shannon,

Why not just place a custom format on the column?