concatenate, force new line
 

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.

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

and make sure that FormatCellsAlignment Wrap text is set

--

HTH

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


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

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

and make sure that FormatCellsAlignment Wrap text is set

--

HTH

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


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


.