1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel: How to delete rows with certain value?

Discussion in 'Black Hat SEO' started by theadultsplayground, Nov 6, 2015.

  1. theadultsplayground

    theadultsplayground BANNED BANNED

    Joined:
    Jan 24, 2008
    Messages:
    1,202
    Likes Received:
    336
    Hello,

    I have email list and I want to delete all rows which are gmail emails. I know how to find rown with gmail.com value, but how to delete them all from the list?
     
  2. marttali

    marttali Junior Member

    Joined:
    Sep 3, 2007
    Messages:
    154
    Likes Received:
    34
    One way to do that is by using filter (apply custom filter contains gmail.com) and then delete all what filter caught. Done.
     
  3. Conor

    Conor Elite Member

    Joined:
    Nov 7, 2012
    Messages:
    3,579
    Likes Received:
    5,964
    Gender:
    Male
    Location:
    South Africa
    Home Page:
    Do a search in excel. Click "find all". It should show a list of all the matching results. CTRL A that list to highlight them all. Press delete.

    Done and done.
     
  4. HoNeYBiRD

    HoNeYBiRD Jr. VIP Jr. VIP

    Joined:
    May 1, 2009
    Messages:
    7,502
    Likes Received:
    8,427
    Gender:
    Male
    Occupation:
    Geographer, Tourism Manager
    Location:
    Ghosted
    i hate Excel with all my passion lol, but you can easily do it in Notepad++

    so open the file in Notepad++/copy-paste the content
    hit ctrl+f, that will bring up the 'Search' popup
    navigate to the 'Mark' tab, type "gmail.com" in the 'Find what' field without the quotation marks of course, make sure that the 'Bookmark line' box is checked, hit 'Mark all', then go to 'Search/Bookmark/Remove Bookmarked Lines'

    here's a screenshot for easier understanding:

    [​IMG]
     
  5. Seowarlords

    Seowarlords Junior Member

    Joined:
    Oct 12, 2015
    Messages:
    101
    Likes Received:
    12
    Home Page:
    You can also use conditional formatting excel feature and the custom sort option to delete all gmail emails:

    Select your Column -> Conditional Formatting -> Highlight Cells Rules - > Text that Contains "gmail" -> Sort filter -> Custom Sort -> Sort on Cell Color -> select all and delete
     
  6. burgtech

    burgtech Junior Member

    Joined:
    Sep 14, 2015
    Messages:
    153
    Likes Received:
    10
    Use Sort Option
    All gmail ids will be in a place
    then manually delete these one