Format cells in column A of sheet Result to wrap text.
In cell A10 of Result enter
='Data'!A1 & CHAR(10) &'Data'!A2 & CHAR(10) & 'Data'!A3

--
Regards

Roger Govier


"Uncle O" wrote in message
...
I put questionaires results in excel worksheet. In several columns, the
data
is in text format. I want to shows all the text in another worksheet as a
summary of result. I can't find any formula suitable for the task. Any
suggestion?

eg.
In worksheet "Data!"
Col_A
Mary is a good girl.
John nice.
Ruby the best.

I would like to show it on worksheet "Result!"
| Col A
------------------------------------------------
Row 10 | Mary is a good girl.
| John nice.
| Ruby the best.
|
------------------------------------------------
Row 11 |

Uncle O