TaskPipes will be shutting down 30th November 2018. Please migrate any processes to an alternative solution before then.
Pretty Simple, just use the following formula:
e.g. you could use =ISNUMBER(SEARCH("banana", A1)) to see if "banana" is contained within cell A1.