Hi Marknib,

Oh.. is the the whole "9059 Ser: F8R8WF1290810473" part in one cell? And, you are trying to pull the last 16 digits? And, most importantly, are the consistent in 16 digits for the last part?

If that's the case, apply the following formula.

=right(referencing cell,16)

Once completed in that cell, just drag it down and it should do the job.

However, if you see inconsistent result (part number being cut off etc..) you may have a few extra spaces in the beginning or end or that referencing cell. If that's the case, enter =trim(referencing cell) upon inserting an extra column just right of the referencing column, which should eliminate all the unwanted spaces. Then, in insert another column next to it and apply the "=right" formula mentioned above.

That should do it.