Concat two cells with an LF.

  • Thread starter Thread starter Julian Milano
  • Start date Start date
J

Julian Milano

In XL, you can type text, press Alt-Enter to goto a new line in the cell,
and type more text. Can this be done as a formula? I tried-

=IF(E10="",C9 &CHAR(10)&C10)

which gives me the text from both cells with an outlined square between
them.
 
Julian-

Select the cell with the formula in it and format the cell to "Wrap"
(Format > Cells > Alignment (tab) > Wrap Text)
 
Back
Top