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
    Lola Gill 6.78K 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
      0
      IS 2.20K 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
        ×

        Login

        Question stats

        • Active
        • Views454 times
        • Answers2 answers
        • Followers1 follower