|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 20th, 2010, 05:16 PM
posted to microsoft.public.office.misc
|
|||
|
|||
Converting a list of email addresss that are in one cell, outhorizontilly to all emails in a single column
I have searched for a way to do this, also have ASAP Utilities unable
to find a solution. All of the email addresss are seperated by a comma. I'd like the finished list to be all in one column, instead of all in one cell. Thank you for your time! Mike 
|
|
#2
February 20th, 2010, 05:32 PM
posted to microsoft.public.office.misc
|
|||
|
|||
|
Converting a list of email addresss that are in one cell, out horizontilly to all emails in a single column
There may be an easier way, but what comes to mind is a two-step process:
In Excel help, you can search for "parse", and there are instructions for distributing the contents of a cell into columns. (You don't mention what version of Excel you have, so the exact steps may differ. Help should tell you how.) The comma is your delimiter. Once it's in separate cells in columns, do a transposition. You copy them, then "Paste Special" and choose "Transpose" to transpose them into rows. -- Susan Ramlet -- please reply to the newsgroup so all may benefit. "Michael" wrote in message ... I have searched for a way to do this, also have ASAP Utilities unable to find a solution. All of the email addresss are seperated by a comma. I'd like the finished list to be all in one column, instead of all in one cell. Thank you for your time! Mike
|
|
#3
February 20th, 2010, 05:33 PM
posted to microsoft.public.office.misc
|
|||
|
|||
|
Converting a list of email addresss that are in one cell, outhorizontilly to all emails in a single column
On Feb 20, 12:16*pm, Michael wrote:
I have searched for a way to do this, also have ASAP Utilities unable to find a solution. All of the email addresss are seperated by a comma. *I'd like the finished list to be all in one column, instead of all in one cell. Thank you for your time! Mike Sorry, MS Excel 2007
|
|
#4
February 20th, 2010, 06:57 PM
posted to microsoft.public.office.misc
|
|||
|
|||
|
Converting a list of email addresss that are in one cell, outhorizontilly to all emails in a single column
On Feb 20, 12:32*pm, "Susan Ramlet"
wrote: There may be an easier way, but what comes to mind is a two-step process: In Excel help, you can search for "parse", and there are instructions for distributing the contents of a cell into columns. (You don't mention what version of Excel you have, so the exact steps may differ. Help should tell you how.) The comma is your delimiter. Once it's in separate cells in columns, do a transposition. You copy them, then "Paste Special" and choose "Transpose" to transpose them into rows. -- Susan Ramlet -- please reply to the newsgroup so all may benefit. "Michael" wrote in message ... I have searched for a way to do this, also have ASAP Utilities unable to find a solution. All of the email addresss are seperated by a comma. *I'd like the finished list to be all in one column, instead of all in one cell. Thank you for your time! Mike- Hide quoted text - - Show quoted text - Thank you very much, that did the job! (I did note on my second post above that we had MS Excel 2007)
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
