I am using an Excel-file consisting of a few thousand rows and three columns. Column three consists of text descriptions, and I want to search these cells for multiple keywords. It seems to be difficult to do this in Excel – I can only search for singular words or strings of text.

Is it possible to do an AND/OR/NOT-type of search in Excel, or do somebody have a suggestion about how I could do that in some other way? I have tried to copy the spreadsheet to MS Access but the cells contain to much text for Access.

I appreciate any tip.

/Johan