How do I search for more than one text character in one cell?
I have a column with different names in one row. And one cell where it could
be that one of the names of the column can be shown. My goal is to find a way
how to search for this one word in the cell...
I've tried... but I got an error and I don't know which one!
e.g:
MATCH(TRUE,ISNUMBER(SEARCH("*"&J11&"*","*"&A1:A4&" *")),0)
Thanks for any help in andvance!
|