J judith Jun 7, 2004 #1 How do I combine the contents of two cells with an Alt enter between the two. Something like =c3 & ???? & C4 Thanks
How do I combine the contents of two cells with an Alt enter between the two. Something like =c3 & ???? & C4 Thanks
A Andy Brown Jun 7, 2004 #2 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
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 Jun 7, 2004 #3 Hi Judith, Try: =C3 & Char(10) & C4 and make sure the cell format is set to 'wrap text' Cheers
