line feed in cells

[judith]

How do I combine the contents of two cells with an Alt
enter between the two. Something like =c3 & ???? & C4

Thanks

 

[Andy Brown]

How do I combine the contents of two cells with an Alt

enter between the two. Something like =c3 & ???? & C4

Try =C3&CHAR(10)&C4

; you'll have to Format -- Cells -- Alignment to "wrap text" for it to kick
in, probably.

HTH,
Andy

 

[macropod]

Hi Judith,

Try:
=C3 & Char(10) & C4
and make sure the cell format is set to 'wrap text'

Cheers