View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Epinn Epinn is offline
external usenet poster
 
Posts: 605
Default CHAR(10) = ALT+ENTER??

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?

"Olympics2008"

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