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!