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