Find, Select All, Then Delete Everything Else/Copy Select All in MS Excel 2011 for Mac

Hello,

I'm currently using Microsoft Excel 2011 for mac, and I have a long list of data that I'm trying to filter out by term.

Say I have a list of 6000 rows with 20 columns.

I want to do a search for "CEO", have the search find every CEO in the list and then delete everything else (or I have the ability to filter it and then copy it). Any time it get's a hit I want to keep the entire row.
The reason why I'm going this route is because the term "CEO" is buried within descriptions text and is no a standard value in a field, so I can't simply filter.

Any suggestions on how to do this in MS Excel 2011 for mac? If not, any other suggestions on how to do this and what I would need?

Thank you!