how to merge 2 cells and have them on 2 separate lines in that cell, one
above the other.

Try this:

=A1 & CHAR(10) & B1

Then set the cell to wrap text.

CHAR(10) is equivalent to Alt-Enter if you typed it yourself.

Hope this helps.

Pete

On Aug 13, 4:33*pm, Kerry wrote:
how to merge 2 cells and have them on 2 separate lines in that cell, one
above the other.

I don't understand what you're trying to do. Merging (shudder) is usually
done to give the appearance of one cell. However, you state that you want the
2 cells to appear as seperate lines. If you want them to appear seperate, why
nto leave them seperate?

Merging tends to cause so many more problems, as it interferes with copy,
paste, sort, VB, formula extrapolation, etc.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kerry" wrote:

how to merge 2 cells and have them on 2 separate lines in that cell, one
above the other.

Try :

=A2&char(10)&B2

Make sure your formula cell is set to Wrap Text (Format/Cells/Alignment)

"Kerry" wrote:

how to merge 2 cells and have them on 2 separate lines in that cell, one
above the other.

That is just what I needed, worked perfect.

Thanks

"Pete_UK" wrote:

Try this:

=A1 & CHAR(10) & B1

Then set the cell to wrap text.

CHAR(10) is equivalent to Alt-Enter if you typed it yourself.

Hope this helps.

Pete

On Aug 13, 4:33 pm, Kerry wrote:
how to merge 2 cells and have them on 2 separate lines in that cell, one
above the other.

That is just what I needed, works perfect.

Thanks

"Sean Timmons" wrote:

Try :

=A2&char(10)&B2

Make sure your formula cell is set to Wrap Text (Format/Cells/Alignment)

"Kerry" wrote:

how to merge 2 cells and have them on 2 separate lines in that cell, one
above the other.

You're welcome, Kerry - thanks for feeding back.

Pete

On Aug 13, 5:07*pm, Kerry wrote:
That is just what I needed, worked perfect.

Thanks



"Pete_UK" wrote:
Try this:

=A1 & CHAR(10) & B1

Then set the cell to wrap text.

CHAR(10) is equivalent to Alt-Enter if you typed it yourself.

Hope this helps.

Pete

On Aug 13, 4:33 pm, Kerry wrote:
how to merge 2 cells and have them on 2 separate lines in that cell, one
above the other.- Hide quoted text -

- Show quoted text -

Thank you for the reply!

"Kerry" wrote:

That is just what I needed, works perfect.

Thanks

"Sean Timmons" wrote:

Try :

=A2&char(10)&B2

Make sure your formula cell is set to Wrap Text (Format/Cells/Alignment)

"Kerry" wrote:

how to merge 2 cells and have them on 2 separate lines in that cell, one
above the other.