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

Email lists help

Discussion in 'White Hat SEO' started by Findx, Aug 3, 2012.

  1. Findx

    Findx Newbie

    Joined:
    Jul 22, 2012
    Messages:
    40
    Likes Received:
    9
    I have a list with over 60,000 emails. But the thing is I need to clean it up, because its currently in a txt file (or excel since i can import it to excel)
    The lines are as followed

    nickname | email address |
    nickname2 | email address2 |
    nickname3 | email address3 |
    ... and so on and so fourth

    Then about 30,000 down they change back to front

    email address 30k | nickname30k
    email address 31k | nickname31k
    ...
    Is there any excel code I can use that can get rid of everything and just leave the emails?
    There are spaces between the vertical bar and the email address, so maybe there is a macro that says delete everything except from string "email address"
    Can anyone help?

    (sorry cant post links)
     
  2. Findx

    Findx Newbie

    Joined:
    Jul 22, 2012
    Messages:
    40
    Likes Received:
    9
    nevermind, just solved it. please delete thread
     
  3. mrphuho

    mrphuho Newbie

    Joined:
    Apr 26, 2012
    Messages:
    41
    Likes Received:
    28
    Location:
    somewhere only me know
    google!