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. Check out Portland Wild, a visual map-driven guide to Portland's public art, its Heritage Trees and its Little Free Libraries.

Leave a reply

Your email address will not be published. Required fields are marked *