CHAR(10) = ALT+ENTER??
FormatCellsAlignmentWrap Text
--
Regards
Roger Govier
"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
|