If cell contains. If you want to do something when a cell contains specific text, you can wrap the formula in an IF statement like this: =IF(ISNUMBER(SEARCH(substring,text)), Yes, No) Instead of returning TRUE or FALSE, the formula above, will return Yes if substring is found and No if not.