> -----Original Message----- > From: IBM Mainframe Discussion List > [mailto:[EMAIL PROTECTED] On Behalf Of Ed. Benoit > Sent: Wednesday, December 05, 2007 8:48 AM > To: IBM-MAIN@BAMA.UA.EDU > 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.
Man, like totally off-topic, dude. Unless you have Word and Excel running under on a zSeries mainframe! [grin] Do you mean that the Word document has only email addresses and nothing else? Have you considered doing a "find and replace" to replace the commas with paragraph marks? Then cut and paste into Excel. -- John McKown Senior Systems Programmer HealthMarkets Keeping the Promise of Affordable Coverage Administrative Services Group Information Technology The information contained in this e-mail message may be privileged and/or confidential. It is for intended addressee(s) only. If you are not the intended recipient, you are hereby notified that any disclosure, reproduction, distribution or other use of this communication is strictly prohibited and could, in certain circumstances, be a criminal offense. If you have received this e-mail in error, please notify the sender by reply and delete this message without copying or disclosing it. ---------------------------------------------------------------------- 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