Concatenate

A

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
 
S

Sukhjeet

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
 
A

Andy B

Wrap text has to be selected too!

--
Andy.


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