Making a CSV from several collumns in excell

P

patrick007

Hi,


I have several words in a collumn and have to separate them with
comma; example: bibo, test, bibo, test,

and to place them on one line.

How can I do that fast, because I have a lot of cullums to change i
bibo, test, bibo, test,

Thanks,

Patric
 
M

Murray

Patrick

Hopefully I have understood what you want to do correctly. If so, try
this

Highlight the cells in the column and Edit->Copy
Then, on a new worksheet, Edit->Paste Special and tick Transpose. This
should get the column onto a single row. Do this for each column.

Then to make a comma separated list; File->Save As and Save as Type
"Comma Delimited (*.csv)"

Regards

Murray
 
P

patrick007

Hi,

Thanks for the help, the transpose function works but after saving i
comma delimited .CSV the text stays in the different cells and there i
no comma after the words.

I hope you can advise me, have a nice day,

Patric
 
D

David Biddulph

patrick007 said:
Hi,

Thanks for the help, the transpose function works but after saving in
comma delimited .CSV the text stays in the different cells and there is
no comma after the words.
Click to expand...

Have you looked at the CSV with something like Notepad, or have you imported
it back into Excel? Doing the latter, you won't see the commas, but they
will have been there in the CSV you produced.
 
Top