Hi

You can use the formula below to concatentate the comments

=CONCATENATE(Sheet2!A1;Sheet3!A1)

BUT if the concatentated text is longer than the merged cells, then it won't
show the rest of the text.

I would rather use a formula like the one below to show all comments,
leaving cells empty if no entry was made. Then you can have a little macro
to hide empty rows in the comment area.

Best regards,
Per
"Dumidu Roshan (Hotmail)" skrev i meddelelsen
...
hi everyone
I have a workbook with 12 sheets in them
it got 11 sheets for 11 employees say Fred Kathy mark so on...
every worksheet has row 30 to 33 to column A to U reserved for employee
comments
A30 to u30 is merged cell so is a31 to u31 and so on.. to type in long
lines of comments
main page adds up all the times they worked
in the main page I want to display comments from all the employee sheets
can you add text or string together like numbers? how do I do this?
thanks
dumi