+ Reply to Thread
Results 1 to 7 of 7

Put all cells in one cell seperated by comma

  1. #1
    Registered User
    Join Date
    08-03-2005
    Posts
    1

    Put all cells in one cell seperated by comma

    I have an Excel spreadsheet with data in seperate cells such as

    wordone
    wordtwo
    wordthree

    I need all cells in one cell seperated by a comma such as

    wordone,wordtwo,wordthree

    I found out how to add the comma after the cell data, but cannot figure out how to put them all in the first cell.

    Can anyone help?

    Christine

  2. #2
    Anne Troy
    Guest

    Re: Put all cells in one cell seperated by comma

    =a1&","&a2&","&a3&","&a4&","&a5&","&a6....
    *******************
    ~Anne Troy

    www.OfficeArticles.com


    "kokopoko" <kokopoko.1t7ted_1123117566.7831@excelforum-nospam.com> wrote in
    message news:kokopoko.1t7ted_1123117566.7831@excelforum-nospam.com...
    >
    > I have an Excel spreadsheet with data in seperate cells such as
    >
    > wordone
    > wordtwo
    > wordthree
    >
    > I need all cells in one cell seperated by a comma such as
    >
    > wordone,wordtwo,wordthree
    >
    > I found out how to add the comma after the cell data, but cannot figure
    > out how to put them all in the first cell.
    >
    > Can anyone help?
    >
    > Christine
    >
    >
    > --
    > kokopoko
    > ------------------------------------------------------------------------
    > kokopoko's Profile:

    http://www.excelforum.com/member.php...o&userid=25892
    > View this thread: http://www.excelforum.com/showthread...hreadid=392760
    >




  3. #3
    Alan
    Guest

    Re: Put all cells in one cell seperated by comma

    "kokopoko"
    <kokopoko.1t7ted_1123117566.7831@excelforum-nospam.com>
    wrote in message
    news:kokopoko.1t7ted_1123117566.7831@excelforum-nospam.com...
    >
    > I have an Excel spreadsheet with data in seperate cells such as
    >
    > wordone
    > wordtwo
    > wordthree
    >
    > I need all cells in one cell seperated by a comma such as
    >
    > wordone,wordtwo,wordthree
    >
    > I found out how to add the comma after the cell data, but cannot
    > figure out how to put them all in the first cell.
    >
    > Can anyone help?
    >
    > Christine
    >


    Save the worksheet as a comma separated values file (CSV format).

    You might have to export the range (copy / paste?) to a spare workbook
    first, but it should work fine.

    Backup before doinging ANYTHING!

    HTH,

    Alan.




  4. #4
    Marc
    Guest

    Re: Put all cells in one cell seperated by comma

    Try the function "CONCATENATE"

    Marc

    "Alan" <alan@alan.alan> wrote in message
    news:uBOvMQLmFHA.2628@tk2msftngp13.phx.gbl...
    > "kokopoko"
    > <kokopoko.1t7ted_1123117566.7831@excelforum-nospam.com>
    > wrote in message
    > news:kokopoko.1t7ted_1123117566.7831@excelforum-nospam.com...
    > >
    > > I have an Excel spreadsheet with data in seperate cells such as
    > >
    > > wordone
    > > wordtwo
    > > wordthree
    > >
    > > I need all cells in one cell seperated by a comma such as
    > >
    > > wordone,wordtwo,wordthree
    > >
    > > I found out how to add the comma after the cell data, but cannot
    > > figure out how to put them all in the first cell.
    > >
    > > Can anyone help?
    > >
    > > Christine
    > >

    >
    > Save the worksheet as a comma separated values file (CSV format).
    >
    > You might have to export the range (copy / paste?) to a spare workbook
    > first, but it should work fine.
    >
    > Backup before doinging ANYTHING!
    >
    > HTH,
    >
    > Alan.
    >
    >
    >




  5. #5
    Forum Contributor
    Join Date
    06-10-2005
    Location
    Central Jersey
    Posts
    117
    Quote Originally Posted by Marc
    Try the function "CONCATENATE"

    Marc
    Just tried this function for the first time cause of this post, cool function. Didn't know excel could do that.

    =CONCATENATE(D1,",",D2,",",D3)

    D1=Wordone
    D2=Wordtwo
    D3=Wordthree
    -Joseph

  6. #6
    Marc
    Guest

    Re: Put all cells in one cell seperated by comma

    You feel meek when you stand in front of Excel there is just so much it can
    do.

    Marc

    "malik641" <malik641.1t9quf_1123207541.9757@excelforum-nospam.com> wrote in
    message news:malik641.1t9quf_1123207541.9757@excelforum-nospam.com...
    >
    > Marc Wrote:
    > > Try the function "CONCATENATE"
    > >
    > > Marc
    > >

    > Just tried this function for the first time cause of this post, cool
    > function. Didn't know excel could do that.
    >
    > =CONCATENATE(D1,",",D2,",",D3)
    >
    > D1=Wordone
    > D2=Wordtwo
    > D3=Wordthree
    >
    >
    > --
    > malik641
    >
    >
    > ------------------------------------------------------------------------
    > malik641's Profile:

    http://www.excelforum.com/member.php...o&userid=24190
    > View this thread: http://www.excelforum.com/showthread...hreadid=392760
    >




  7. #7
    Forum Contributor
    Join Date
    06-10-2005
    Location
    Central Jersey
    Posts
    117
    Quote Originally Posted by Marc
    You feel meek when you stand in front of Excel there is just so much it can
    do.

    Marc
    You Suuuuuuuuure do

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1