Data validation

[Hans Knudsen]

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

 

[Leo Heuser]

Hej Hans

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

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

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