Find and Replace Help

  • Thread starter Thread starter John
  • Start date Start date
J

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???
 
perhaps this formula will help?
=IF(LEFT(A2,2)="99",--MID(A2,3,999),A2)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS word Find and Replace using Regex - Help required 0
box combination formula 8
Formula / Function Problem 5
Help on conversion 3
how do I lock or freeze cells 1
Simple question- please help! 5
Formula??? 3
Replacing data in a cell 3

Back
Top