Reduce sheet to rows with certain value

I have a spreadsheet with 34K rows. I would like to reduce to only the rows that include a certain word. What is the best way to accomplish?
thanks, Jay

Let's assume you're looking for "car" (including cars, etc) in column A, beginning in A2.
In a blank column row 2, use the formula

=IF(ISNUMBER(SEARCH("car",A2)),1,"")

Then do an autofilter on that column for Blanks and delete the blank rows. Does that work for you?

A formula inserted into an empty column designed to check each of the cells in the row for the "word"...and provide a count if it is found anywhere in the row, something like this in row 2 (you need "titles" in row 1):

=COUNTIF(A2:H2, "*word*")

Now copy that formula down the 34k rows and let it calculate.

Then click on ROW1 and turn on the AutoFilter. Data > Filter > AutoFilter

Then filter that new column, use custom > less than 1...or just choose zero from the drop list. Either way, filter by the zeros and delete all the rows left visible all at once. Then turn off the AutoFilter and you're done.

If the match only has to occur in one column, then use ChemistB's approach.

1) Insert a blank row at the top

2) Put this formula in G2:
=IF(ISNUMBER(SEARCH("car", D2)), 1, "")

3) Copy that cell down the whole dataset

4) Use the autofilter as described

Sweeeeeeeet!!!

THANK YOU