two lines in a cell

[Guest]

I am trying to get multiple lines to display in a cell without merging . I have to display text such a

1. Hello my name i
2. Duncan LeBlan

on two lines in a single cell. The cell width is long and currently I need to insert the appropriate spaces to have the second line of text move down.
The issue arises when I print as the display in either Normal view or Print Preview shows that the text is on two lines, but it prints with parts of the second line on the first line
Is there any command or function that can be used to allow me to get 2 or 3 lineds of text formatted on different lines in a cell?

 

[Paul]

I am trying to get multiple lines to display in a cell without merging . I have to display text such as

1. Hello my name is
2. Duncan LeBlanc

on two lines in a single cell. The cell width is long and currently I

need to insert the appropriate spaces to have the second line of text move
down.

The issue arises when I print as the display in either Normal view or

Print Preview shows that the text is on two lines, but it prints with parts
of the second line on the first line.

Is there any command or function that can be used to allow me to get 2 or

3 lineds of text formatted on different lines in a cell?

Use Alt+Enter to put a line break at the appropriate place in your text.

 

[Peo Sjoblom]

For each line break press Alt + Enter

--

Regards,

Peo Sjoblom

I am trying to get multiple lines to display in a cell without merging . I have to display text such as

1. Hello my name is
2. Duncan LeBlanc

on two lines in a single cell. The cell width is long and currently I

need to insert the appropriate spaces to have the second line of text move
down.

The issue arises when I print as the display in either Normal view or

Print Preview shows that the text is on two lines, but it prints with parts
of the second line on the first line.

Is there any command or function that can be used to allow me to get 2 or

3 lineds of text formatted on different lines in a cell?

 

[AH]

Hi Duncan,

When writing text into a cell, you can press Alt + Enter to make an
internal line break. The same thing you can do by inserting an ASCII code 10
into a cell. You can do it like this:

= "Hello my name is"&CHAR(10)&"Duncan LeBlanc"

Remember that in cell formatting you have to check the wrap text option.

- Asser

I am trying to get multiple lines to display in a cell without merging . I have to display text such as

1. Hello my name is
2. Duncan LeBlanc

on two lines in a single cell. The cell width is long and currently I

need to insert the appropriate spaces to have the second line of text move
down.

The issue arises when I print as the display in either Normal view or

Print Preview shows that the text is on two lines, but it prints with parts
of the second line on the first line.

Is there any command or function that can be used to allow me to get 2 or

3 lineds of text formatted on different lines in a cell?