software

I am attempting to combine three columns into one. This is not a problem.
However, I would like to combine the info into two 'lines' in the result
field. On the keyboard I would use 'Alt' 'Enter'. Is there a 'special'
code for this 'Alt' 'Enter' that I can include in a formula?

Result Column1 Column2 Column3
----------------------------------------------------
Foltz Foltz Dan Sue
Dan amp; Sue
----------------------------------------------------
Result is only 1 cell.

I can handle the remainder of the formula but need to 'hard' code for the
'Alt' 'Shift'. LLike in Word, you can do a find for a paragraph marker by
using '^p' or a tab using '^t'.

Thanks for any help you might provide.
Dan

Try =A1amp;CHAR(10)amp;B1
You will need to use: Format | Cell -gt; alignment -gt;wrap text
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;DannyDontquot; gt; wrote in message
...
gt;I am attempting to combine three columns into one. This is not a problem.
gt; However, I would like to combine the info into two 'lines' in the result
gt; field. On the keyboard I would use 'Alt' 'Enter'. Is there a
gt; 'special'
gt; code for this 'Alt' 'Enter' that I can include in a formula?
gt;
gt; Result Column1 Column2 Column3
gt; ----------------------------------------------------
gt; Foltz Foltz Dan Sue
gt; Dan amp; Sue
gt; ----------------------------------------------------
gt; Result is only 1 cell.
gt;
gt; I can handle the remainder of the formula but need to 'hard' code for the
gt; 'Alt' 'Shift'. LLike in Word, you can do a find for a paragraph marker
gt; by
gt; using '^p' or a tab using '^t'.
gt;
gt; Thanks for any help you might provide.
gt; Dan