Need an expert on MS Excel.

[mattsmusiccenter]

Wow, that worked great and saved me a shitload of time. Thanks VERY much guys!

I think the find and replace would be the easiest way to do this.

ctrl+f

copy the code that you want to get rid of.

I don't have excel on this computer but it's not too hard, there should be a replace tab or advanced tab.

Then just fill in the "replace with:' as a blank

http://support.microsoft.com/kb/288291

[Jack The Riffer]

So who gets the big discount on their next purchase???

[DonP]

And how long might something like this take?

Sorry it took so long to get back; busy day at work today. Gotta make the cash to pay for the guitars.

It wouldn't take long (minutes). Depends on how big the sheet is, and how fast the computer is.

But, like I thought, someone had a quicker way.

My way would work better if you just needed to cut out X many characters (to the right or left), but they weren't always the same characters (which would prevent the ctrl-f from working because you'd have to type in a new value to find and replace each time).