Hej Hans

You have to format the receiving cell (E5) as "Wrap text".

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Hans Knudsen" skrev i en meddelelse
...
I have tried the following which doesn't work:

In Sheet1 I have formulas like this one: =E12&CHAR(10)&F12 where E12 holds
the text Actual and F12 the number 2004. I have named the
range with these formulas "Headings". In Sheet2 I have the report where
one of the headings (cell E5) should be Actual 2004 and
shown as if I press Alt+Enter between Actual and 2004. If I use Data
validation by referring to List, Headings I get Actual, then
the CHAR(10) symbol, and then 2004 on one line.

What else can I do to obtain the line break when I have many heading
variants to choose between?

Hans Knudsen