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" <[email protected]> wrote in message
news:[email protected]...
>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
>
Bookmarks