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

%3CLINGO-SUB%20id%3D%22lingo-sub-333114%22%20slang%3D%22en-US%22%3EHow%20to%20delete%20rows%20that%20include%20a%20specific%20value%20in%20a%20column%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-333114%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20approx.%204500%20rows.%20The%20cells%20in%20column%20K%20contain%20an%20email%20address.%20Some%20of%20the%20email%20addresses%20have%20been%20auto-generated%20by%20Booking.com.%20I%20want%20to%20delete%20all%20rows%20that%20contain%20%22%40guest.booking.com%22%26nbsp%3B%20in%20the%20K%20column%20cells.%20Note%20that%26nbsp%3B%22%40guest.booking.com%22%20will%20only%20be%20the%20end%20portion%20of%20the%20email%20address%20cell%20%E2%80%A6%20there%20will%20be%20lead%20characters%20in%20front%20of%20the%20cells%20containing%26nbsp%3B%22%40guest.booking.com%22%20%E2%80%A6%20please%20help%20me%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-333114%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-333427%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20delete%20rows%20that%20include%20a%20specific%20value%20in%20a%20column%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-333427%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20the%20below%20formula%20in%20the%20next%20column%20to%20know%20which%20cell%20contains%26nbsp%3B%22guest.booking.com%22.%3C%2FP%3E%3CPRE%3E%3DISNUMBER(SEARCH(%22guest.booking.com%22%2CA2))%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%201.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F72407iE3750CC48CD96F39%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screenshot%201.png%22%20alt%3D%22Screenshot%201.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20that%2C%20you%20can%20sort%20the%20new%20TRUE%2FFALSE%20column%20from%20A%20to%20Z%20to%20move%20all%20true%20values%20to%20the%20bottom%20to%20be%20able%20to%20highlight%20them%20all%20and%20delete%20them%20at%20once.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202.png%22%20style%3D%22width%3A%20982px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F72408i5AD81F45D797D9F5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screenshot%202.png%22%20alt%3D%22Screenshot%202.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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 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

1 Reply
Highlighted

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

 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