Format the cell with wrap on
--
Gary's Student


"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? Thanks.

Epinn