View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Find if nth char = specific character..

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


"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.