combining cells

W

wayne

I would like to combine two cells into one and do a "carriage return" so that
the data from the second cell is started on a new line....ie
a1 b1
FAULT TEST CASE

would like to get the result of:

a1
FAULT
TEST CASE

in the same cell.

Anyone offer any assistance.

Thank you.
 
B

Bob Phillips

=A1&CHR(10)&B1

and do Format>Cells>Alignment>Wrap text on this cell

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
D

David Biddulph

I think Bob may have intended
=A1&CHAR(10)&B1
rather than
=A1&CHR(10)&B1 ?
 
Top