Help me clear html codes in CSV

0

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
    1
    IS 2.20K 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
      ×

      Login

      Question stats

      • Active
      • Views528 times
      • Answers1 answer
      • Followers1 follower