Ed. Benoit wrote: >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? You go to z/OS, FTP your MSWORD doc as a text file using ASCII/EBCDIC translation, write a REXX prog to create a CSV file and FTP back to your PC. Saves you 'Click you here, click you there and voila!' ;-D Oops. wait. This is a z/OS forum? ;-D There are two alternatives beside the other advices you received. Do just a COPY/PASTE. Select that cell and use 'Text to Columns'. Use Blanks and Commas to separate your email addresses. You will have 1 e-mail address in each cell in a row. Have each e-mail address on its own line in M$Word doc. Use your common COPY/PASTE operation with or without commas. HTH! Groete / Greetings Elardus Engelbrecht ---------------------------------------------------------------------- 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
