=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.