alt + enter in a formula
 

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

alt + enter in a formula
 

=A1&CHAR(10)&B2

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

HTH,
Paul

--

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