I created a column that strips the characters to leave a number (Eng1 becomes 1)=RIGHT(D57, LEN(D57)-3).

Then, in another column I use the function =if(f2=g2,"ID","OOD"). The function doesn't work at all. However, when I go into the cell that has the =RIGHT(D57, LEN(D57)-3) and replace it with a number... the if function =if(f2=g2,"ID","OOD") works perfectly.

Any suggestions?

Thanks for your time in helping with this...it's driving me nuts!