Add A Line In A Text Cell

[Minitman]

Greetings,

I need to add a line in a cell being used as a header. There are
three ways to do this:

1) Use Char(10) in a formula - disadvantage is no formatting (Size,
color or font)

2) Use a LOT of spaces - disadvantage is it looks messy and sometimes
does unexpected things.

3) Use some keystroke combination to force a line feed - disadvantage
is you cannot mix text and formulas (I can live with that)..

I am looking for number 3.

Anyone know what that keystroke combination is?

Any help is appreciated, thanks.

-Minitman

 

[Gary''s Student]

You don't need a formula to insert the CHAR(10):

In a cell:

helloALT-ENTERworld

What I mean ( I confused even myself) is that after typing the o in hello,
touch ALT-ENTER before typing world

 

[Minitman]

Hey Gary's Student,


Thanks for the fast reply

That is what I was looking for.

Thanks.

-Minitman