Column A Column B
ABC.1AA AA
EFG.XBB BB
HIJ.UCC CC
KLM.1AA AA
jhde.XBB BB
tyjss.UCC CC
I am using the formula: =IF(A2=".1AA",AA,(If (A2=".XBB","BB",If(A2=".UCC","CC",0))))
How do I make it look at the last 3 or 4 characters and return a specific value if true ?
I appreciate the help and support.
Bookmarks