I format the cell as suggested and it works fine now. No F2 needed.
Which version do you have? Do you see that little square that RD mentioned?

Epinn

wrote in message oups.com...
Epinn wrote:
A1: The Olympics
B1: 2008
C1: =A1&CHAR(10)&B1

I expect the result in C1 to be

The Olympics
2008

But, I have

The Olympics 2008

I don't get the ALT+ENTER effect using CHAR(10) for line feed.
What have I missed?

I find that sometimes, I must select the cell and press F2 in order to
get the desired effect. I do not know why.