how to merge 2 cells and have them on 2 separate lines in a cell
 

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

how to merge 2 cells and have them on 2 separate lines in a cell
 

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.

how to merge 2 cells and have them on 2 separate lines in a cell
 

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.

how to merge 2 cells and have them on 2 separate lines in a cell
 

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.

how to merge 2 cells and have them on 2 separate lines in a ce
 

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.

how to merge 2 cells and have them on 2 separate lines in a ce
 

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.

how to merge 2 cells and have them on 2 separate lines in a ce
 

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 -

how to merge 2 cells and have them on 2 separate lines in a ce
 

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.