Two Text Lines in one Cell.

C

Chip Pearson

Peter,

When you type text in to a cell, use ALT+Enter to insert a line
break. To combine two cells in to a single cell, you can use a
formula like =A1&CHAR(10)&A2 . Ensure that the cell has Wrap Text
formatting enabled.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top