Excel 2007 : Selective row critera +Delete Characters

**Rebel_42MDx** · 03-11-2010, 02:57 AM

New to VBA obviously. I have a file about 20K rows deep. I need to find all rows that begin with 2010 and delete the first 43 characters of that row.

Any help great appreciated.

Reb

**JBeaucaire** · 03-11-2010, 05:07 AM

Care to post up a 30-40 row excerpt so we can accurately ascertain your goal? Perhaps BEFORE/AFTER sheets based on that short sample? Some people say rows when they mean columns, or even cells. Best if we just look at it.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

**Rebel_42MDx** · 03-11-2010, 11:06 AM

Thanks for the help. Here are the "before" and "after" sheets. Thank you again as I am trying to learn VBA.

**JBeaucaire** · 03-11-2010, 12:13 PM

Hehe, see, looking at an actual sheet presents much clearer picture of the need. What you really want is a way to search for STORE: and delete all the characters in cell up to and including those characters, yes? Much simpler.

This will do that:

Please Login or Register  to view this content.

**Rebel_42MDx** · 03-11-2010, 12:43 PM

WOW! Works like a charm and runs very fast. You da' man!!! Thanks for your help and patience. As a CPA I'm trying to bridge the gap between VBA and crunching numbers.

Thanks again!

Reb