Thread: Removeing certian numbers from a row of numbers
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Removeing certian numbers from a row of numbers
Possibly:

If *all* numbers are 6 characters long and start with 011:

Enter 11000 in an empty cell

Copy that cell: EditCopy
Select the range of cells that contain your numbers
Then, EditPaste SpecialSubtractOK

--
Biff
Microsoft Excel MVP


"Claude" wrote in message
...
Example:
011402
011403
011404

How can I remove 011 from a list of 10,000 prefixes?
If anyone can help out I would really appreate it.



Reply With QuoteReply With Quote