Google-sheets – How to delete all rows containing given text that could be in any column within the row

google sheets

I'd like to be able to delete all rows in a Google Spreadsheets where a given text string exists anywhere in the row. The text being searched for could be in any cell in the row, and also could be part of a longer string within the row cell e.g. "xxxx [text being searched for] yyy".

Best Answer

I think I understand your question. Have you tried using the search and replace feature? I believe there's an add on for that if sheets doesn't have it by default.