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.
Bookmarks