concatenate, force new line

[JohnT]

when i input text in a cell i can use alt-enter to force a
new line....is there a way to force a new line of text
when using concatenate....joining text strings from
various other cells? thanks in advance.

 

[Bob Phillips]

="This is one line"&CHAR(10)&"and this is another"

and make sure that Format>Cells>Alignment Wrap text is set

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

excellent! thanks

-----Original Message-----
="This is one line"&CHAR(10)&"and this is another"

and make sure that Format>Cells>Alignment Wrap text is set

--

HTH

RP
(remove nothere from the email address if mailing direct)





.