greentatertot1970
asked on
Evaluating last character of a string with IF function
I am sure that there is a way to do this but it is not clear to me how...
I am using an IF statement. I would like the logical_test parameter to evaluate a strings last character.
EXAMPLE:
=IF(A1 end with a "T","String 1","String 2")
I am using an IF statement. I would like the logical_test parameter to evaluate a strings last character.
EXAMPLE:
=IF(A1 end with a "T","String 1","String 2")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect - thank you both!
=IF(RIGHT(TRIM(A1),1)="T",