Hi,

You will have to wrap text (from Format cells)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Khoshravan" wrote in message
...
A1=Apple B1=Orange
I was expecting by this formula to get:
Apple
Orange (In two lines in a cell)
But I get:
AppleOrange
Char(10) didn't work for me.
I am using Excel 2003
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Pete_UK" wrote:

Like this:

=A1 & CHAR(10) & B1

CHAR(10) is the linefeed character (equivalent to Alt-Enter when you
do it manually).

Hope this helps.

Pete

On Feb 6, 1:08 am,
wrote:
How do I enter a hard return between two fields I concatenate?