You can use a formula like this to indicate cells that contain text in Excel. Any cell that contains the strings tips, help or support will show up as true, otherwise they will be false:
=OR(ISNUMBER(SEARCH("tips",D2)),ISNUMBER(SEARCH("help",D2)),ISNUMBER(SEARCH("support",D2)))
Share this: