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