comma separation

[stephen-]

- when I paste some columns and rows into a new spreadsheet, I get this new window where I can choose for tab or comma separation, but when I paste columns and rows that are correct, they are automatically separated by tabs, what is normal
but I want to change the separation by comma's, and I really don't know how I should do that, at least I can't find any menu item that has the possibility to change the separation and the help menu didn't help me much either

so, can I change the separation manually or is that only possible when I paste new cells? -

- or can anyone help me creating a .csv file that I can use to import contacts to gmail, caus I tried almost everything, and the gmail guide can't fix my problem either. Actually I had a .csv file of all my contacts, but gmail didn't accept it, maybe caus the .csv file contained more than just names and addresses, but also phone numbers. And when I adjusted everything, so the file only contained names and addresses I couldn't change the separation by comma's anymore -

[David]

[ftack]

Hallo, Belgium. You should be able to use Calc to change the delimiter in a cvs file. Suppose al your data are in a text file separated by tab. Rename it to csv and retrieve it in Calc (file - Open. The Text Import dialig appears, where you must specify 'Separated by tab'". Then first save to Ooo spreadsheet (otherwise Calc will not ask for csv settings), then back to CSV, this time specifying comma as field delimiter.

You will end up with either " or ' around the strings. Chances are that this will be fine for the program where you want to import. Otherwise, remove them using a text editor. Eventually, Writer can be used for this, but then, you will need to rename the file to *.txt. Otherwise OOo will insist on opening it in Calc.

[stephen-]

it works now
thanks for the help

greetz from belgium