Quote Originally Posted by kellyfspringer View Post
=RIGHT(A2,LEN(A2)-2)
If they are all UN then 4 digits, you can shorten that formula to
=RIGHT(A2,4)
Where would you put that to reference all 2250 cells? yes they are all UN followed by 4 digits.