Placing a Return in a Function

J

jdurrmsu

I am trying to link two cells together with an return between them.
Everytime that I do this I end up with a little square in between th
two values. An example of the formula that I am using is as follows:

=A1&"
"&A2

I want my single cell A3 for example to look like this:

23
50

And not like this 23[]50.

Please Help. Thanks
 
M

Mike

=a1&char(10)&a2
and that does not even work
Only workaround I can think of is wrapping the text and shrinking the column
width.
Or a3 has a1 and b3 has a2 and wiping out the border.
 
J

jdurrmsu

Thanks. I tried the Char(10) as well and it did not work. I forgot t
enable the word wrap function and that was the problem. Thanks
 
Top