| 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 | |||
Hybrid Mode
