After downloading the individual responses in CSV, the responses include the HTML Codes I have included while building the survey.How can I clear the codes at ago without deleting manually-one by one? Is there a code I have to write in VBA?
I would like the following answer without the codes:
One option is that you could edit the survey to change the reporting values and then re-export your data
When editing a question, you can click on “Advanced Option Settings” and choose “Reporting Values: Custom”. This lets you show one thing while the survey is being taken (the version with html) while still reporting the clean version without html.
You can also usually strip the html in Excel very easily using Find and Replace. Simple find:
and replace with nothing.