Try the formula

=Sheet2!A1 & " " & Sheet3!A1

OR

=Sheet2!A1 & char(10) & Sheet3!A1
'Apply wraptext to this cell to list down the values in separate lines..

If this post helps click Yes
---------------
Jacob Skaria


"akutach" wrote:

I am trying to make a label from an Excel file. The content for one of the
cells to be printed is found in other cells on a different worksheet of the
same file.

How do you automatically put the values (#s and text) from multiple cells as
a list into one cell (the one to be printed)?