Survey Results - font issues

JimS373
Member

Survey Results - font issues

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. 

1 REPLY 1
Timothy_G
Employee

Hello @JimS373,

 

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.


Timothy_G
Community & Social Media Support

Did I answer your question? If so, please mark my post as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.

You're not alone on your email marketing journey. Connect with a Marketing Advisor to see how they can help you develop the right strategy for your business and get the most out of your Constant Contact experience.