Making a CSV from several collumns in excell
 

Hi,


I have several words in a collumn and have to separate them with a
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 in
bibo, test, bibo, test,

Thanks,

Patrick


--
patrick007
------------------------------------------------------------------------
patrick007's Profile: http://www.excelforum.com/member.php...o&userid=37060
View this thread: http://www.excelforum.com/showthread...hreadid=567811

Making a CSV from several collumns in excell
 

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 wrote:
Hi,


I have several words in a collumn and have to separate them with a
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 in
bibo, test, bibo, test,

Thanks,

Patrick


--
patrick007
------------------------------------------------------------------------
patrick007's Profile: http://www.excelforum.com/member.php...o&userid=37060
View this thread: http://www.excelforum.com/showthread...hreadid=567811

Making a CSV from several collumns in excell
 

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.

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

Patrick


--
patrick007
------------------------------------------------------------------------
patrick007's Profile: http://www.excelforum.com/member.php...o&userid=37060
View this thread: http://www.excelforum.com/showthread...hreadid=567811

Making a CSV from several collumns in excell
 

"patrick007" wrote
in message ...

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.
--
David Biddulph