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

Anyone good at Excel?

Discussion in 'Black Hat SEO' started by iShred, Apr 24, 2010.

  1. iShred

    iShred Registered Member

    Joined:
    Nov 19, 2009
    Messages:
    84
    Likes Received:
    272
    Location:
    Indiana
    Home Page:
    Okay here's what I need to do..

    One cell has a list of usernames in this format.. user1, user2, user3, etc..

    and i want excel to fetch each of those usernames and put them in their own cells, like

    user1
    user2
    user3

    ... there are 1600 usernames, so without something slightly automated it'll take forever..

    any ideas?
     
  2. greatusa

    greatusa Registered Member

    Joined:
    Feb 11, 2008
    Messages:
    95
    Likes Received:
    22
    try something like format - text to column functionality. it should werk : )
     
    • Thanks Thanks x 1
  3. iShred

    iShred Registered Member

    Joined:
    Nov 19, 2009
    Messages:
    84
    Likes Received:
    272
    Location:
    Indiana
    Home Page:
    ahh thank you, yeah just saw that on google..