You could use =RIGHT(A1,9), where A1 is the cell containing your
original data. This will pick up the last 9 digits.........only works
if your original text strings are identical in length though.

HTH


--
penri0_0


------------------------------------------------------------------------
penri0_0's Profile: http://www.excelforum.com/member.php...o&userid=28947
View this thread: http://www.excelforum.com/showthread...hreadid=549409