ExcelBanter - Find and Replace Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Find and Replace Help (https://www.excelbanter.com/excel-discussion-misc-queries/256700-find-replace-help.html)

John

Find and Replace Help

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

Find and Replace Help

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

All times are GMT +1. The time now is 03:30 PM.