Help me clear html codes in CSV


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:

IS answered
    IS 2.21K Rep.

    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. 

    IS answered


      Question stats

      • Active
      • Views3155 times
      • Answers1 answer
      • Followers1 follower