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.

=A1&CHR(10)&B1

and do FormatCellsAlignmentWrap text on this cell

--
---
HTH

Bob

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



"wayne" wrote in message
...
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.

Try:-

Format|cells|alignment|wordwrap.

Mike

"wayne" wrote:

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.

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

"Bob Phillips" wrote in message
...
=A1&CHR(10)&B1

and do FormatCellsAlignmentWrap text on this cell

"wayne" wrote in message
...
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.