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

[JMS05181950]

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 contain "@guest.booking.com"  in the K column cells. Note that "@guest.booking.com" will only be the end portion of the email address cell … there will be lead characters in front of the cells containing "@guest.booking.com" … please help me

[#2]

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.