The Community is hosting an End of Summer sweepstakes! Participants must complete tasks to earn tickets that will enter them with a chance to win a free year of Constant Contact and other great prizes!*
*No Purchase Necessary. For Official Rules, visit here. Constant Contact’s End of Summer 2020 Sweepstakes ends on October, 20, 2020 at 11:50 PM EST.

Survey Results - font issues

Occasional Contributor

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. 


Re: Survey Results - font issues

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.

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.
Constant Contact 2020 End of Summer Community Sweepstakes!

The Constant Contact User Community is hosting a sweepstakes. The more you participate, the more chances you have to win! Read on to learn more...

Read More