Concatenate with multiple lines in one 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.


any help will be very much appreciated.


USer Friendly
DopeShow

 

[Frank Kabel]

Hi
try
= A1 &" raining " & A4 & CHAR(10) & "next line" & A6

 

[Dave R.]

I think that will work (with the little boxes it puts in), but make sure to
go into the format of the cell to alignment and select "wrap text" and make
sure the column is wide enough to break where you want it to.

 

[DrHunter]

sorry, but i couldn't get that to work! giving me similar result. is
CHAR(10) the ASCI character for the return key or next line?

 

[Frank Kabel]

Hi
CHAR(10) is a nextline (AKT+ENTER). You may have to format the cell
with word wrap to see the results (goto 'Format - Cells - Alignment'
and check word wrap -> hope this is the correct translation of this
dialog)

 

[DrHunter]

Hello Frank,
Thanks for your conternous help, but i realise if the cell is long enough,
the whole sentence fits in one line. Is there any other way i can get the
formular to begin the next line where i preciesely want it to be without
having to format the cell.

The reason being i would want to out the result to another program and i
want it to read it line by line. i dont want to use different cells for
different lines.

Thanks again and i hope one of you guys can crack this.

 

[Frank Kabel]

Hi
what I tried to say was that you have to use both in combination:
- the concatenation function with CHAR(10)
- the cell formating with word wrap (even if the cell is wide enough)

Only in this situation the CHAR(10) will force a new line