I have a suggestions column in a survey feedback that's being pushed from the survey provider to a google spreadsheet. I'm trying to do a bit of wording analysis on it so for example I'm trying to count the number of occurrences of the word "Difficult" in it.

I already found a way by concatenating all the feedback and splitting it into cells and then comparing the cells with the word .. this is not scalable, looks like google has a limit on the amount of words I can squish into one cell and so the concatenate function is giving me an error. I'm hoping to use the search or find function but I can't seem to figure out how to count the words in the column

Here's an example of what I'm trying to do  https://docs.google.com/spreadsheets/d/1vTSDVQZX1WslozVS3e4G44_U7Bptu-8hXPnMbPkKyhQ/edit?usp=sharing

I have a suggestions column in a survey feedback, that's being pushed from the survey provider to a Google Spreadsheet. I'm trying to do a bit of wording analysis on it. For example, I'm trying to count the number of occurrences of the word "Difficult".

I already found a way by concatenating all the feedback and splitting it into cells and then comparing the cells with the word, but this is not scalable. It looks like Google has a limit on the amount of words I can squish into one cell and so the concatenate function is giving me an error. I'm hoping to use the SEARCH or FIND function, but I can't seem to figure out how to count the words in the column.

Here's an example of what I'm trying to do: counting of words

I have a suggestions column in a survey feedback that's being pushed from the survey provider to a google spreadsheet. I'm trying to do a bit of wording analysis on it so for example I'm trying to count the number of occurrences of the word "Difficult" in it.

I already found a way by concatenating all the feedback and splitting it into cells and then comparing the cells with the word .. this is not scalable, looks like google has a limit on the amount of words I can squish into one cell and so the concatenate function is giving me an error. I'm hoping to use the search or find function but I can't seem to figure out how to count the words in the column

Here's an example of what I'm trying to do https://docs.google.com/spreadsheets/d/1vTSDVQZX1WslozVS3e4G44_U7Bptu-8hXPnMbPkKyhQ/edit?usp=sharing

Hope you can help :(

Cheers,

I have a suggestions column in a survey feedback that's being pushed from the survey provider to a google spreadsheet. I'm trying to do a bit of wording analysis on it so for example I'm trying to count the number of occurrences of the word "Difficult" in it.

I already found a way by concatenating all the feedback and splitting it into cells and then comparing the cells with the word .. this is not scalable, looks like google has a limit on the amount of words I can squish into one cell and so the concatenate function is giving me an error. I'm hoping to use the search or find function but I can't seem to figure out how to count the words in the column

Here's an example of what I'm trying to do https://docs.google.com/spreadsheets/d/1vTSDVQZX1WslozVS3e4G44_U7Bptu-8hXPnMbPkKyhQ/edit?usp=sharing