Forum Discussion
How to delete rows that include a specific value in a column cell
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 Booking.com. I want to delete all rows that contai...
Hi,
You can use the below formula in the next column to know which cell contains "guest.booking.com".
=ISNUMBER(SEARCH("guest.booking.com",A2))
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.