Text answers been synced into Excel with quotations.
Ex: John saved as “’John” in Excel
Question
Excel integration putting quotes in text answers
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), “”)
+5Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.