[sfboek]

Hello

I did do a search by could not find an answer.

When I export the calibre library database to a CSV file, my columns are separated by the comma character.

When I open this file in an Excel sheet all my data are in one column.
The I use Select Data > Text to Columns.

Unfortunately, most of my books are written by more than 1 writer.
These writers are also separated by the comma character.
When I have 3 writers, these writers are moved to 3 columns, because they are also separated by a comma. So the title of this book will be in column 4
When I have 2 writers, the title of the book will be in column 3.
So in column 3 I have sometimes the third writer and sometimes the title of the book.
And ofcourse the titel of the books contains sometimes a comma.

Is it possible to change the comma for the column into someting else

Thanks Simon