Newline (char(13)) in a formula

[Frank]

Hi

I'd like to have a formula in a cel display its resultstring in multiple
lines:

e.g. if I have the following formula: ="First line of text" & Char(13) &
"Second line of text"
I would like to display it in two line in a single cell. If i do it like
above i get a small square in stead of a newline break.

How can I achieve this?

Thanks a lot!

 

[Frank]

Just to be complete, ive also troed char(10) and that also does not work

 

[Bob Umlas]

Use Char(10) and also format it as wrap text
Bob Umlas

 

[joeu2004]

I'd like to have a formula in a cel display its resultstring in multiple
lines:
e.g. if I have the following formula: ="First line of text" & Char(13) &
"Second line of text"

Rather than a formula, can you simply enter the following text:

First line of text<alt-Enter>Second line of text

<alt-Enter> means that you press and hold the Alt key while press the
Enter key.

Note: As always, you might need to expand the width of the cell in
order to see the two lines exactly as you intend them. Suprisingly,
Autofit does not do the job (at least not in Office Excel 2003).

You can also use alt-Enter within a string in a formula; it is the same
as concatenating char(10). For example:

=if(true, "Line one<alt-Enter>Line two")

But you will see a square box, not a new line, unless you format the
cell to Wrap Text (Format > Cells > Alignment).

 

[joeu2004]

I'd like to have a formula in a cel display its resultstring in multiple
lines:
e.g. if I have the following formula: ="First line of text" & Char(13) &
"Second line of text"

Rather than a formula, can you simply enter the following text:

First line of text<alt-Enter>Second line of text

<alt-Enter> means that you press and hold the Alt key while press the
Enter key.

Note: As always, you might need to expand the width of the cell in
order to see the two lines exactly as you intend them. Suprisingly,
Autofit does not do the job (at least not in Office Excel 2003).

You can also use alt-Enter within a string in a formula; it is the same
as concatenating char(10). For example:

=if(true, "Line one<alt-Enter>Line two")

But you will see a square box, not a new line, unless you format the
cell to Wrap Text (Format > Cells > Alignment).

 

[Frank]

That did it, i forgot to format as wrap text, thats why it did not work in
first time.

Thanks Bob!