TaskPipes will be shutting down 30th November 2018. Please migrate any processes to an alternative solution before then.

How to see if a cell contains a word


Pretty Simple, just use the following formula:

=ISNUMBER(SEARCH(word_to_search_for,text))

e.g. you could use =ISNUMBER(SEARCH("banana", A1)) to see if "banana" is contained within cell A1.