software

I know I can wrap text, but that doesn't work when the first line should be
shorter than the second and/or third.

I know there must be a character out there that drops you down to the next
line. I have been copying amp; pasting the space between one line and the next
on other people's documents so I can make it work on my documents, but there
must be a key or something people are typing to get that to work. Can someone
fill me in on this secret? It's such a mystery.

alt-enter will force a new line in a cell.

In a formula:
=quot;some textquot; amp; char(10) amp; quot;some morequot;
(with wrap text turned on)

batdance wrote:
gt;
gt; I know I can wrap text, but that doesn't work when the first line should be
gt; shorter than the second and/or third.
gt;
gt; I know there must be a character out there that drops you down to the next
gt; line. I have been copying amp; pasting the space between one line and the next
gt; on other people's documents so I can make it work on my documents, but there
gt; must be a key or something people are typing to get that to work. Can someone
gt; fill me in on this secret? It's such a mystery.

--

Dave Peterson

At the end of your line of text press lt;Altgt;lt;Entergt; to force a new line
and keep doing this as you type the text in to give you more lines.

Hope this helps.

Petelt;Altgt;lt;Entergt;!

quot;batdancequot; wrote:

gt; I know I can wrap text, but that doesn't work when the first line should be
gt; shorter than the second and/or third.
gt;
gt; I know there must be a character out there that drops you down to the next
gt; line. I have been copying amp; pasting the space between one line and the next
gt; on other people's documents so I can make it work on my documents, but there
gt; must be a key or something people are typing to get that to work. Can someone
gt; fill me in on this secret? It's such a mystery.

When you want a carriage return in a cell, Hold down Alt key and hit Enter

Philip
quot;batdancequot; gt; wrote in message
...
gt;I know I can wrap text, but that doesn't work when the first line should be
gt; shorter than the second and/or third.
gt;
gt; I know there must be a character out there that drops you down to the next
gt; line. I have been copying amp; pasting the space between one line and the
gt; next
gt; on other people's documents so I can make it work on my documents, but
gt; there
gt; must be a key or something people are typing to get that to work. Can
gt; someone
gt; fill me in on this secret? It's such a mystery.