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

M

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
 
S

Susan Ramlet

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.
 
M

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

Sorry, MS Excel 2007
 
M

Michael

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.









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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top