View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Completely Confused Completely Confused is offline
external usenet poster
 
Posts: 1
Default HOW DO I DELETE NUMBERS IN A COLUMN out of each cell

I have a list of part numbers in a column, over 5000, and I need to change it
while keeping other information in tact. For example

1025-00-128-5463 (Each of these numbers are in a cell which
totals
1025-00-255-5656 5000. They are listed in a column.)
1025-00-233-5666

I need to delete the first four numbers and all the dash marks so they will
look like this
001285463
002555656
002335666

If I tried to do this individually I would waste a lot of time. Please help
and remember I am new to this program. Any help would be sincerely
appreciated
Thanks Dave