=substitute(RIGHT(A1,11),"-","")

and copy down

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Completely Confused" <Completely wrote
in message ...
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