Assuming all of your data follows the same pattern as your example, place
this formula in an adjacent column.

=MID(A1,10,7)

Copy down as far as needed.

If you then want to delete the original data, follow these steps:

Copy your new column of data
While that column is still selected, choose "Paste Special" from the Edit Menu
Check the "Values" option
Click OK
Now, delete your original column

HTH,
Elkar


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