People numbered their answers and now we have big numbers in our word clouds that misrepresent what is actually important. Thanks!
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″,””)
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!
