Apostrophes removed and replaced in export | Community
Skip to main content
Answered

Apostrophes removed and replaced in export

U

Upon exporting my results as a CVS file, all text that includes an apostrophe is replaced.

 

For example:

What’s is replaced with what‚Äôs

I’ve is replaced with I‚Äôve

It’s is replaced with it‚Äôs

Didn't is replaced with didn‚Äôt

Etc. 

 

How can I export the file without this happening? Find and replace doesn’t seem to work.

Best answer by Liz

Hi @UnitOneClub1 Do you happen to be exporting the CSV version and opening it up in Excel, rather than the XLSX version? If so, you’ll want to download the XLSX version to avoid the formatting issues. 

View original

3 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 15013 replies
  • October 3, 2023

Hi @UnitOneClub1 Could you share a screenshot of what you’re seeing in the export and in the responses? Thanks!

Life is a series of awkward moments separated by snacks.
U
  • UnitOneClub1
  • Author
  • Explorer
  • 1 reply
  • October 5, 2023

Hi Liz, of course. I’ll attach it to this message.

Thank you

Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 15013 replies
  • Answer
  • October 6, 2023

Hi @UnitOneClub1 Do you happen to be exporting the CSV version and opening it up in Excel, rather than the XLSX version? If so, you’ll want to download the XLSX version to avoid the formatting issues. 

Life is a series of awkward moments separated by snacks.

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs