Format C1 to wrap text. Initially, you may see this:

The
Olympics
2008

Then widen the column and you'll get what you want.

ALT ENTER automatically wraps text but you would still need to widen the
column.

Biff

"Epinn" wrote in message
...
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? Thanks.

Epinn