1) import them into your spreadsheet 2) Select them all to copy them 3) Right click on the selected entries and click on "COPY" 4) Move down 1 row in the first column 5) Right click in this column and select "PASTE SPECIAL" 6) On the paste special, click the selection "Transpose" 7) Click on "OK" 8) After the copy completes, delete your first row
-----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Ed. Benoit Sent: Wednesday, December 05, 2007 8:48 AM To: [email protected] Subject: Excel Question Hello All, Any Excel List that I can ask these questions? I have some email addresses in a WORD document separated by commas and I would like to get them in a EXCEL document in the first column. Copy paste do not work because Excel will spread them out to all columns. (1) Is there a way to do this with copy and paste that I do not know? (2) Are there any software on the market that will accomplished this task? Ed. **************************************Check out AOL's list of 2007's hottest products. (http://money.aol.com/special/hot-products-2007?NCID=aoltop0003000000000 1) ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
