Answered

Apostrophes removed and replaced in export

  • 3 October 2023
  • 3 replies
  • 48 views
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.

icon

Best answer by Liz 6 October 2023, 15:32

View original

3 replies

Liz
Rank
Userlevel 7
Badge +5

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

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

Thank you

Liz
Rank
Userlevel 7
Badge +5

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