From Excel column to coma?

F

Fts

I have a 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
 
G

Gordon

Fts said:
I have a 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
Click to expand...


Select the data, then do Copy, Paste-Special-Transpose.
 
B

Bob I

Is that all there is on the sheet? If so "Copy, Paste Special,
Transpose" and then save as .CSV file. Open that file in Word.
 
F

Fts

I need to have the comas though. Perhaps in excel I can add a coma (is there
a way to add a character to all cells?) to each cell automatically? If so how.
Thanks
 
B

Bob Buckland ?:-\)

Hi FTS,

When you save as a CSV file the resulting file will separate each item of data in a row by a comma, for you. If you add a comma in
Excel then save as CSV you will have commas in quotes and then the comma separator.
(You can open a .CSV file in Notepad to see how it's setup.

You can use Edit=>Replace in Excel to add an extra comma to each cell.

==============
I need to have the comas though. Perhaps in excel I can add a coma (is there
a way to add a character to all cells?) to each cell automatically? If so how.
Thanks >>
--

Bob Buckland ?:)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*
 
F

Fts

Thanks guys,
(You can use Edit=>Replace in Excel to add an extra comma to each cell)
On the sample above I showed all the words as the same but in reality all
the words in my column are different. Is there a way to add a comma to all
the cells in another way?
Thanks again.
 
Top