Tag: hlookup

How to Find Cells That Contain Text in Excel

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

/ August 11, 2013