Thread: CHAR(10) = ALT+ENTER??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Epinn Epinn is offline
external usenet poster
  
Posts: 605
Default CHAR(10) = ALT+ENTER??
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



Reply With QuoteReply With Quote