I'm trying to export my CC survey results but whenever a respondent used an apostrophe, it converts it to gobbledygook. When exporting to xls format, it ends the comment at the "apostrophe."
I receive a font error when opening the file, so I suspect that's behind it.
Is there anyway I can get around this? It's a PITA.
Currently, there is no way to prevent the characters converting wrongly. The quickest fix would be to export the CSV version of the report into Excel, then use the replace function (CTRL-H) to replace the code with the correct symbol.