line feed in cells

J

judith

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

Thanks
 
A

Andy Brown

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

Try =C3&CHAR(10)&C4

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

HTH,
Andy
 
M

macropod

Hi Judith,

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

Cheers
 
Top