USING IF STATEMENT ??

[imported_unknown]

I NEED TO KNOW IF A LENTH OF WORDS CONTAIN A CERTAIN PATTERN. FOR EXAMPLE I MAY HAVE
"LAXMEX" OR "MEXNYC", IF THIS WORD CONTAINS
MEX, THEN I WOULD LIKE TO KNOW. THE FILTER FUNCTION DOES THIS, BUT I WANT TO USE A FORMULA SO CERTAIN INFO IS NOT ELIMINATED.

 

[zzydhf]

try:

=FIND("mex",A1)

 

[lenze]

Have a look at the SEARCH worksheet function in the help files

 

[imported_unknown]

THANKS......THIS IS WHAT I NEEDED.
HAVE A GREAT DAY.....MARTHA

 

[Mark W.]

=ISNUMBER(SEARCH("MEX",A2))