Ps. What does eliminate mean?

You could use a helper worksheet and some formulas.
in A1 of that helper sheet:

=If(countif(sheet1!a1,"*bob*")0,sheet1!a1,"")

Drag down as far as you need and then drag as far right as you need.

wrote:

Dave I got this to work but the problem with it is that it returns all
the rows that include the keyword but it also includes everything else
in that row, so I still end up searching the spreadsheet for the
keyword with my eyes. Is there anything I can add that will eliminate
the rest of the cells that do not include the keyword?

--

Dave Peterson