I wonder if anyone can help with an issue which has been frustrating me for a while? We use feedback in Moodle often. When response data is exported to Excel the 'multiple choice - multiple answers' questions amalgamate each respondent's responses to that question in one cell in Excel. This makes data analysis difficult.
I'd like to separate the individual answers into separate cells which I could do if I could see what Moodle inserts to separate those answers. There must be something as, when double clicked, the cell formats the answers as if there were a hard line return between each of them. However this is not a hard line return as I have tried a 'find and replace' to look for any hard line returns and it brings back a null return.
Does anyone know how Moodle formats this output for Excel?
Alternatively, has anyone found a different solution to this dilemma? I have resorted in the past to separating each option into its own 'multiple choice - single answer' question which works, but is inefficient for the respondent.
I'm using Moodle 2.7.1. Any suggestions welcome!