Making a CSV from several collumns in excell

[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

 

[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

 

[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

 

[David Biddulph]

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.

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.