Check if 3rd character in string is "i"

Hi there,

This seems simple enough in theory... but alas I have not yet been able to work out a solution.

I have a string in cell A1 "oetyu"

What formula could I use to check if the THIRD character is equal to "i" ? If it is, I want to return TRUE and if not I want to return FALSE (which will be the case in this example).

Thanks in advance
Michelle

FYI, if you want the formula to be case sensitive (where "i" is seen as different from "I"), you can use this:

=EXACT(MID(A1,3,1),"i")

Originally Posted by AliGW

Try this:

=MID(A1,3,1)="i"

Thanks-you =)