Hi,

Try the MID function.

=MID(A1,5,1)="A"

Cheers
Andy

nastech wrote:
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.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info