How can I insert a search box into a spreadsheet that searches comma separated values in cells?

Deleted 

Hi

The function used to search for a keyword is called "Search"
If you type "Apple" as a keyword in Cell B1 and you want to search in the Range A5:A50 for the existence of this keyword,

You can type IsNumber(Search($B$1,A1)) >> and copy it all the way down >> it will return a TRUE if the keyword exists and a FALSE if the keyword does not exist

Using this concept with an advanced filter enables you to extract the record having the keyword.

If you have multiple keywords then, you need to include your function in an OR function and put the keywords in separate cells.

Should you wish a more customized answer then post an Excel spreadsheet with sample data.

Thanks

Nabil Mourad