Hi,

I am trying to identify particular characters in a certain position in a text string in a cell.

i.e. look for a J or F in the 9th position of a text string and return Y or N

I have used =IF(MID(A2,9,1)="J","found","not found") to find 1 character, but am wondering how to look for 2 in the one position? How can I combine the 2 IFs in one formula?