View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DrHunter DrHunter is offline
external usenet poster
 
Posts: 2
Default Concatenate with multiple lines in same cell

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.