Concatenate

[Andy]

Hi,

I have a simple concatenate formula that joins two stings
of text together, is it possible to somehow get the second
string of text to appear below the first sting but within
the same cell. (basically a carriage return)

Many thanks

Andy

 

[Andy B]

Hi

Try
=A1 & CHAR(10) & A2

 

[Andy]

thank you

-----Original Message-----
Hi

Try
=A1 & CHAR(10) & A2

--
Andy.





.

 

[Guest]

Already tried that - does not work. Displays a box where the char(10) should be, without moving the contents of A2 to the next line

----- Andy B wrote: ----

H

Tr
=A1 & CHAR(10) & A

 

[Andy B]

Wrap text has to be selected too!

--
Andy.

Already tried that - does not work. Displays a box where the char(10)

should be, without moving the contents of A2 to the next line.