How do we remove numbers in our word clouds?

0

People numbered their answers and now we have big numbers in our word clouds that misrepresent what is actually important. Thanks!

IS answered
    0
    IS 1.87K Rep.

    There are other, more complex, things you could do, but one option might be to export your data, use Excel or a similar tool to remove the numerals, then re-import the altered data.

    An Excel formula like the following would give the value of cell A2 with the numerals removed:

    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,”0″,””),”1″,””),”2″,””),”3″,””),”4″,””),”5″,””),”6″,””),”7″,””),”8″,””),”9″,””)

    IS answered
      0
      Lola Gill 6.46K Rep.

      There is not an option to remove specific pieces of text from a Word Cloud. One suggestion is to clean up/edit the original responses that submitted these numbers so that the numbers don’t make it to the report to begin with:

      https://help.surveygizmo.com/help/viewing-responses#editing-responses

      Hope this helps!

      Lola Gill answered
        ×

        Login

        Question stats

        • Active
        • Views200 times
        • Answers2 answers
        • Followers1 follower