Converting a list of email addresss that are in one cell, outhorizontilly to all emails in a single

[Michael]

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

 

[Susan Ramlet]

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

news:b5d33a99-f262-490c-b194-a2d72c097160@k41g2000yqm.googlegroups.com...

> 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

 

[Michael]

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

 

[Michael]

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

>

> news:b5d33a99-f262-490c-b194-a2d72c097160@k41g2000yqm.googlegroups.com...

>

>

>

> > 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)