Not sure why you are having a problem!
When I create a CSV catalog using standard Calibre settings, all fields are enclosed in quotes so that any commas embedded in the field are ignored for separator purposes. Using your example I end up with:
"author 1, author2", "title", ....
which is what I would expect for a CSV file.
If I load the result into Excel (again with default settings) it loads into each column exactly what I expect with the authors all loading into the same column regardless of how many there are..
Last edited by itimpi; 10-14-2011 at 05:35 AM.