forced linefeed

[Pierre Laporte]

I want to insert a forced line feed in a cell containing text. To insert it
in a text I use the <alt><return>.
Now my question is how do I insert it in a cell that I create by merging two
texts.

= A3 & " " & A4

What do I put in between the double quotes to have a forced linefeed in my
cell ?

Tks

 

[Dan Elgaard]

Hi,

=A3 & CHAR(10) & A4

Remember to format the cell with wordwrap.

 

[Trevor]

Word Wrap! That was the trick. I was using the same code, but getting a
little box instead of the line feed.

Note that the number 10 is specific to the character set you're using. If
your computer is currently using a different character set, you'll have to
use a different number. To deterine which number, go to a cell and type
<Alt><Enter> and press enter. In another cell, type the formula =CODE(A1)
(where A1 is your cell with the line feed in it). Whatever number results
from the formula is the numer you should use. Chances are, though, 10 will
do the trick.

 

[Pierre Laporte]

Just what I needed thanks

Hi,

=A3 & CHAR(10) & A4

Remember to format the cell with wordwrap.