View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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.