Hi,

I need to put an 'if' formula together that is looking for data that contains a certain number of characters.

For example, my current formula which doesn't work is ( i think the "1J" & "2J" elements need to include the right of A:A for the last 2 digits.

=If(A:A="1J","ALM",If(A:A="2J","ALM",If(A:A="A0663J",ALM",if(A:A="J053EJ","ALM","ELM"))))

Any ideas??