I have a cell that looks like this: PJL11100


and (1) I need to populate a cell that pulls the last 2 numbers (00). What formula will extract partial numbers?

(2) I also need another cell to tell me that because the 3rd to last number is 1 and because the last two numbers are 00 that the code should be populated as SAX.

Can anyone help me?