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)))

Posted by Jeff Reifman

Jeff is a technology consultant based in the Pacific Northwest.

Leave a reply

Your email address will not be published.