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

 

[Michael]

On Feb 20, 12:16 pm, Michael <walczakm...@gmail.com> 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

 

[Susan Ramlet]

Re: 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" <walczakmike@gmail.com> 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, 122 pm, "Susan Ramlet"
<shram...@SPAMISBADmanitscoldhere.com> 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" <walczakm...@gmail.com> 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)