Find if nth char = specific character..

N

nastech

hi, trying to find way to see if 5th character equals the letter A.
know / tried: len( or right( but item tested may have more than 5
characters. Thanks.
 
B

Bob Phillips

=IF(MID(A1,5,1)="A","yes","no")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
R

Ron Coderre

Try working with this:

If the text to test is in Cell A1:
B1:=IF(MID(A1,5,1)="A","Yes","No")

Does that point you in the right direction?

***********
Regards,
Ron
 
N

nastech

that's great, thanks..

Ron Coderre said:
Try working with this:

If the text to test is in Cell A1:
B1:=IF(MID(A1,5,1)="A","Yes","No")

Does that point you in the right direction?

***********
Regards,
Ron
Click to expand...
 
Top