Apologies if there is already an answer for this, I can't seem to find it.

I have a CSV file, one column contains words however some will have more than one option.

Is there any easy way to count each word or produce a report of how many times each word is there even though its separated by a comma?

Using a Macbook, not sure if that would make a difference to the answers.

Many thanks