Database of emails problem

Discussion in 'Databases' started by fadetoblack22, Apr 29, 2010.

  1. #1
    I have a list of emails in a text file that look like this:

    ; ; ; ; ; ; ;

    My question is, how do I separate them and put them into excel each in a separate cell?

    thanks.
     
    fadetoblack22, Apr 29, 2010 IP
  2. plog

    plog Peon

    Messages:
    298
    Likes Received:
    11
    Best Answers:
    1
    Trophy Points:
    0
    #2
    You can open Excel, go to File->Open, select your file and Excel should pop-up an import wizard dialog box. Import them as 'Delimited', choose the semi-colon as your delimiter and then finished. It will open and each email will be in its own cell. You can then save this document as a spreadsheet.

    Most likely this isn't exactly what you want or won't work for the ultimate purpose you have for doing this, so after you import it to Excel and realize this, post back and tell me exactly how you want your email imported and the ultimate purpose for doing so.
     
    plog, Apr 29, 2010 IP
    fadetoblack22 likes this.
  3. fadetoblack22

    fadetoblack22 Well-Known Member

    Messages:
    2,399
    Likes Received:
    62
    Best Answers:
    0
    Trophy Points:
    160
    #3
    Hey, thanks for the reply. The problem was that Excel only allows a small minimum amount of columns so cuts the data off after about 250 email addresses. However I used open office and managed to achieve the correct results.
     
    fadetoblack22, Apr 30, 2010 IP