Excel integration putting quotes in text answers | Community
Skip to main content
Question

Excel integration putting quotes in text answers


Text answers been synced into Excel with quotations.

Ex: John saved as “’John” in Excel

2 replies

Forum|alt.badge.img
  • Navigating the Land
  • 6 replies
  • February 3, 2024

Hey bequest, 

It sounds like when the API returns the data to Excel, there's a string formatting error. You can fix this in your excel by either using search > replace all in excel and just replace the quotes with nothing or you can add a new column next to your text column with the following formula: 
 

=SUBSTITUTE(A2, CHAR(34), “”)

Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14984 replies
  • February 9, 2024

Hi @bequest I hope you’re doing well! Did the solution above work for you? 


Reply