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

HOW DO I DELETE NUMBERS IN A COLUMN out of each cell
 

=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

HOW DO I DELETE NUMBERS IN A COLUMN out of each cell
 

If you want to actually alter the current values,
try this 2-step process:

Select your column of values

From the Excel main menu:
<edit<replace
Find what: ????-00-
Replace with: '00 <-that's an apostrophe and 2 zeros
Click [Replace all]

Leave the Replace window open and set
Find what: -
Replace with: (clear this field)
Click [Replace all]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Completely Confused" wrote:

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