Hi guys,

I'm new on this site, and am still trying to get my head around Excel!! I'm having great difficulty on a small part of my college project at the moment, so i'll explain it and see if anyone can help me...

I have to create a quiz/game in excel, which contains several multiple choice answers for each question. I then have to display each selected answer into a paragraph (within one cell) so that each of the selected answers make up a full sentence. for example....

Q (A4): Enter the haunted house?
A (B4): Yes
End sentence (C4): "you have entered the haunted house"

I have the quiz/game set up with IF statements, so that it displays the above horizontally along the row, but i now need each sentence answer (C4;C12) to be displayed in one cell as a paragraph. eg:

"(C4)You have entered the haunted house. (C5)You decide to take the stairs. (C6)You have chosen to pick up the chainsaw."

Can this be done, and if so, how?

Any help on this would be much appreciated!!!