If all you want is the last four digits, you could use a formula such as =RIGHT(A1,4) which would only place the last four digits into the cell in which you have the formula, as shown below.
1234567890123450 3450
_________________________
I hear and I forget. I see and I remember. I do and I understand.--Confucius
Previous Thread
Index