Cell line breaks

[Francis Hookam]

Cell line breaks

Alt+Return puts text on the next line within a cell (as manual line break in
Word)

I need to concatenate text from several cells into a single cell, keeping
the text from each cell on a different line. Is it possible to introduce a
line break into a concatenation?

Francis Hookham

 

[JE McGimpsey]

Cell line breaks

Alt+Return puts text on the next line within a cell (as manual line break in
Word)

I need to concatenate text from several cells into a single cell, keeping
the text from each cell on a different line. Is it possible to introduce a
line break into a concatenation?

= A1 & CHAR(13) & B1

Make sure Wrap Text is enabled.