Assuming the product number is in A1, then in any cell on same row
=MID(A1,10,7)
you may have to play with the 10 and 7 to pull out the exact group you want.
10 is the starting character number and the 7 is how many characters to grab.

Note that that will leave whatever is displayed as text and not a real
number, if you want a real number (which could lose some leading zeros) then
=VALUE(MID(A1,10,7))

If you need to do away with the originals, but keep these results, once
you've gotten them all (fill the formulas down the sheet), then select the
new values and use Edit | Copy and then without changing anything, choose
Edit | Paste Special and choose the [Values] option. The formulas will
disappear, to be replaced by the actual values created. Then you could do
away with column A with the 'ABC... entries completely if needed/desired.



"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.