Concatenate with multiple lines in same cell

[DrHunter]

Hi All,

I am trying to concatenate references to multiple cell, however, i want some
of the results in differrent lines of the same cell. Here is a example:

= A1 &" raining " A4 &" now we go into the next line "
&" still in the same cell" A6
&" and yet again in the same cell"

is what i am trying to do reasonable/ feasible.

I try using ALT+ENTER. but i get a sort of a "square" character appearing in
a single line of concatenation.

 

[Tom Ogilvy]

= A1 &" raining " & A4 &" now we go into the next line " & CHAR(10) &" still
in the same cell" & A6 & CHAR(10) &" and yet again in the same cell"

format the cell to word wrap. Make it wide enough that the longest line
displays on line.