perhaps this formula will help?
=IF(LEFT(A2,2)="99",--MID(A2,3,999),A2)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"John" wrote:

I am trying to fix a data set. Many of the entries have a "99" before the
number. I want to remove the 99 before the actual data I want. Some of the
number have a "99" in the middle of the number so I am having issues....Any
help?


99458481
99458482
99458483
99458484
99459984
458953
458954
459960

Any ideas???