Are you using a formula?

='sheet1'!a1&char(10)&'sheet2'!b2&char(10)&'sheet3 '!c3

Make sure you format the cell for wraptext:
format|cells|alignment tab.
(else you'll see little boxes where the char(10)'s will be)

Nmo11 wrote:

I am trying to merge multiple cells from one worksheet to another. I need a
hard return between a few items so they all line up on the left. Is this
possible or should i try something else?

--

Dave Peterson