Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
Copy contents of Find (Find and Replace) | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions |