Forum Discussion

JMS05181950's avatar
JMS05181950
Copper Contributor
Feb 08, 2019

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

excel
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Feb 09, 2019

    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.

Resources