combining cells

[Guest]

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.

 

[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)

 

[Guest]

Try:-

Format|cells|alignment|wordwrap.

Mike

 

[David Biddulph]

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