SoftMaker.com

Hmmm, strange. When I tried to reproduce the issue it seems to be working as I wanted (which is good). I'm suspecting what may have happened was I thought I chose semi-colon, but it may have ended up being commas again, which resulted in the wrong split of text. I'll replicate the problem next time ...

When saving spreadsheet as a CSV file, the default separator is a comma. However, it becomes an issue if there were originally commas in the text themselves. The logical idea for the user is to use a different separator, like a semi-colon, to avoid a problem like this.

This is not so.

The problem ...