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

Exel help (will give thanks to anybody who answered)

Discussion in 'BlackHat Lounge' started by Typhoon Blogger, Jul 15, 2009.

  1. Typhoon Blogger

    Typhoon Blogger Registered Member

    Joined:
    Jan 29, 2009
    Messages:
    70
    Likes Received:
    7
    hello I have a list of e-mails (Huge more than 1k) and each e-mail is comma separated. I want to make a csv file from them cus everytime I try they get pasted on one cell. I tried everything but i'm new to this things so I though someone else might help. Maybe someone could show me another way of making csv.
    Or just show me how to put these comma separated e-mails each in one row. \\
     
  2. enigman

    enigman Newbie

    Joined:
    Nov 26, 2008
    Messages:
    20
    Likes Received:
    5
    You could try renaming the file from .txt to .csv then open that with excel. Not sure if that will put them all in a vertical row or not but that will get them in their own cells. After that you should be able to move them how you want then re-save as .txt
     
    • Thanks Thanks x 1
  3. Typhoon Blogger

    Typhoon Blogger Registered Member

    Joined:
    Jan 29, 2009
    Messages:
    70
    Likes Received:
    7
    thank you if I don't find another solotion I think I will do it the way you said. I'm currently looking for a php array function which may help.
     
  4. royalmice

    royalmice BANNED BANNED

    Joined:
    Aug 23, 2007
    Messages:
    1,186
    Likes Received:
    982
    In excell click on file, clickall file types, and select your file, somewhre you will now be presented with options, you have to select to open comma and or tab seperated, just pleas ewith it it WILL work
     
    • Thanks Thanks x 1
  5. keropikero

    keropikero Regular Member

    Joined:
    Mar 24, 2009
    Messages:
    246
    Likes Received:
    61
    I assume your file is currently .txt
    In excel, file, open, locate that file
    leave it delimited, click next,
    check the 3rd box for comma
    finish

    Now all your data should be in different cells in one row. If you want them vertically, select the horizontal cells and then while hovering over the selection right-click with your mouse and select "Copy" then select the uppermost cell of where you would like to paste the selection vertically and right-click again, now select "Paste Special..." then check "transpose" then click "OK".
     
    • Thanks Thanks x 1