How to delete rows that include a specific value in a column cell

Occasional Visitor

I have a spreadsheet with approx. 4500 rows. The cells in column K contain an email address. Some of the email addresses have been auto-generated by I want to delete all rows that contain ""  in the K column cells. Note that "" will only be the end portion of the email address cell … there will be lead characters in front of the cells containing "" … please help me

1 Reply



You can use the below formula in the next column to know which cell contains "".


 Screenshot 1.png



After that, you can sort the new TRUE/FALSE column from A to Z to move all true values to the bottom to be able to highlight them all and delete them at once.

Screenshot 2.png