Find and Replace Help

[John]

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???

 

[Luke M]

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