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

--

HTH

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


"nastech" wrote in message
...
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.