If ALL product numbers have the same structu
3-letters,
a space,
several zeros,
the core value,
and 4 ending zeros....

try something like this:

Select the list of ProdNums

From the Excel main menu:
<data<text-to-columns
Check: Fixed Width.........click [Next]
Click to insert a break before the 1st zero
Click to insert a break before the last 4 zero s
Click [Next]
Select the first text column and Check: do not import column
Select the 2nd text column and Check: General format
Select the last text column and Check: do not import column
.........click [Finish]

That will leave the core number.
If formatted as General....the leading zeros will be removed.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"instructorjml" wrote:

My current product number is 'ABC 0000030000030000--yes that is a label
identifier at the beginning of the id. I would like to eliminate the ABC, the
leading zeros, and the four zeros at the end. However, this is the first
number of thousands in the column--all of which change in those middle
numbers that I need to retain.