alt + enter in a formula

[merry_fay]

Hiya,

I'm trying to join 2 cells of text which I need to repeat for a few thousand
lines.
I've used the formula:

=A1&B2
to join them, but is there any way of making B2 start a new line in the cell?

Thanks
merry_fay

 

[PCLIVE]

=A1&CHAR(10)&B2

Your cell format will need to be set to wrap text.

HTH,
Paul