Wednesday, August 3, 2011

FORMULA PLEASE FOR LISTING WORDS THAT END WITH "ISTS"?

=IF(MID(A1.LEN(A1),1="S","OK") WILL DISPLAY WORDS ENDING WITH "S", BUT I WANT THE FORMULA WHERE THE WORD ENDS WITH "ISTS"

0 comments:

Post a Comment