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

In a formula:
="some text" & char(10) & "some more"
(with wrap text turned on)

batdance wrote:

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 & 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.

--

Dave Peterson