Screencap:

http://img329.imageshack.us/img329/5638/char10su5.jpg

Using Excel 2002

Biff

"Epinn" wrote in message
...
Thank you all for your response.

I guess I expected more than CHAR(10) can deliver. <g

Yes, you can say I am inexperienced too. <g

RD, I don't see that small square before 2008. Does everyone see it except
me?
I use V. 2003; which version do you use?

Thanks.

Epinn

"RagDyeR" wrote in message
...
Don't you see a small square between Olympics and 2008?

"Olympics�2008"

You have to now format the cell to "Line Wrap"

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"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