Can some one please help me with a formula? I have several hundred rows in
the same column with the numbers HI0375xxxx. I need to formula to change
that to HI375xxx and take out all the zeros. The numbers vary in the rows
after the "0", but the "0" is always the 3rd charactar. Thank you for anyone
that can help.