Hello,

I'm trying to figure out if there's a way to find and replace the last
two digits on a list of invoice #s if they end with a 01 (replacing
them with nothing). Here's a sample list:

190369734601
190369734701
190369734801
64853
CM1903717092
DM902651322
I1903517714
I90351095901
I90351095902

Can't use the =Left function because the length of the invoice #s
varies. Currently I'm copying the list to a text editor that recognizes
carriage returns so I can find/replace 01<carriage return and then
copy it back to the wksht. It'd be nice if I could find a way to work
it into a macro though. I realize that legitimate invoice numbers may
be affected but they should easily be identified by the difference in
size.

Thanks...