If your results are comma separated in a csv file, Excel will separate them
into different cells.
If you have an Excel file with variables comma separated within a cell, then
you can use Data/ Text to Columns to separate them.
Excel will tend to try to decide on the interpretation of the format of the
data for you, so you may need to force it to what you need (perhaps to text
format). If you look at the archives of this group you will see many
discussions on the subject, but if you have specific problems, come back to
us with more detail.
--
David Biddulph

"downstage" wrote in message
...
Hiya,

I have to analyse some survey results that have been stored as .csv files,
and I've only ever used very basic Excel functions before.

Where a question allowed multiple results, I need a way to count and sort
the given answers. Is there a way to get the comma separated results
entered
into separate cells, without doing it manually? Or is it going to be too
complicated for an Excel beginner, and would be easier to do it the long
way?

Thanks in advance for any help you can give.