I have data from a survey that contains multiple-answer values.

The student can choose up to 18 different answers depending on the
question.

These answers are being entered in a single cell and separated by a
comma, such as 1,3,4,7. For example:

ID Q1 Q2 Q3
1 1,3,4,7 2,4 1,12,18
2 4,5 1,6 1, 7, 9


I am trying to prepare histograms and graphs of the reponses. I've
done this successfully for surveys with single responses, but not with
multiple options.

I have tried to do a frequency function. Excel doesn't want to accept
numbers separated by commas or
spaces as it doesn't count numbers in lists such as above.

I appreciate any help. Thanks!