I have a feeling that there will be surprises if I submit a formula to do this. Are the
first three characters present in all the entries? Should only ABC be removed, or the first
three characters in all entries? Are there always four trailing zeroes, or does that vary?
Are the last four characters always zeroes, or could they be something else, something that
should not be removed? Have I forgotten anything.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"instructorjml" wrote in message
...
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.