Originally Posted by kellyfspringer =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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks