From Excel column to coma

[saatfj]

I have an column of words in Excell...is there a way to convert it to a row where these words are separated by comas. Maybe in Word?




aaaa
aaaa convert to -----> aaaa,aaaa,aaaa,aaaa
aaaa
aaaa



Thanks

[scheungyyz]

try this

select the column (the "aaa"s)
click [Format Cells]
Select [custom]
Type @,
Click OK

then select the cells again, CTRL C to copy
then PASTE SPECIAL
Transpose

then select that row again, paste to word

[Chaitanya_Sagar]

There's another simple way to do it.

1. I assumed data is in A1, A2...
2. Write this formula in B1 =a1
3. Write this formula in B2 =A2&","&B1
4. copy b2 and paste it till the end of data
5. Tada!

Chaitanya