1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Microsoft Office' started by Michael, Feb 20, 2010.

  1. Michael

    Michael Flightless Bird

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

    Michael Flightless Bird

    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
     
  3. Susan Ramlet

    Susan Ramlet Flightless Bird

    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
     
  4. Michael

    Michael Flightless Bird

    On Feb 20, 12:32 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)
     

Share This Page