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.
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.
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.