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

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

www.OfficeArticles.com


"kokopoko" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

"kokopoko"
<[email protected]>
wrote in message
news:[email protected]...
>
> 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.

Try the function "CONCATENATE"

Marc

"Alan" <[email protected]> wrote in message
news:[email protected]...
> "kokopoko"
> <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > 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.
>
>
>

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

Marc

"malik641" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>