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


--
kokopoko
------------------------------------------------------------------------
kokopoko's Profile: http://www.excelforum.com/member.php...o&userid=25892
View this thread: http://www.excelforum.com/showthread...hreadid=392760

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

www.OfficeArticles.com


"kokopoko" wrote in
message ...

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"

wrote in message
...

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" wrote in message
...
"kokopoko"

wrote in message
...

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.

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

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

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

Marc

"malik641" wrote in
message ...

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

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

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

Marc
You Suuuuuuuuure do


--
malik641


------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=392760