In addition, if you are starting with data in a coma separated string such as:
Joe Bolw, John Smith, Willard Brown, .... Replace each delimiter with 5 or 6 delimiters and EXCEK will then start a new row with each like - Joe Blow John Smith Willard Brown . . . -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of HUTCHISON Gregory Sent: Wednesday, December 05, 2007 7:26 AM To: [email protected] Subject: Re: Excel Question I've done similar to this by following these steps: 1. Name your document .csv instead of .doc or whatever it is now 2. Creat a new EXCEL Worksheet 3. Open the EXCEL Worksheet 4. File Menu > Open > change Files of type list to 'All Files(*.*)' Change Look in: drop down list to get where to your .csv file 5. Depending of version of EXCEL this may do what you need If it does not open as you want but instead goes to a wizard then follow instructions through the wizard remembering to highlight everything top to bottom and right to left before clicking finish. If you evey need to do this for data that uses commas such as money fields $12,000 for example then you can change your delimiters to semi colons ';' which is what I use often and make file extention .scs as I do and EXCEL will always use the wizard. Pretty much all you need to do when wizard finishes is change your colom size and save it as a regular SS. This is a handy thing to do say after inserting the semi colons where you want them in a flat file using Syncsort Outrec. Use XMITIP by Lional to email & translate it to you in ASKII as an attachment named with .scs. Open it as above - folllow wizard and you can manipulate the data using EXCEL. -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Ed. Benoit Sent: Wednesday, December 05, 2007 6: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 ---------------------------------------------------------------------- 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 ---------------------------------------------------------------------- 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
