Concatenate with Line Feed not working

[Cummings]

Good morning, all.

trying to combine two cells with a line feed (char(10)) and I just get the
square box.

Tried copying the example in EXCEL help, but still got the square box.

Used both the CONCATENAT function and the ampersands. Still get the square
box.

ALT-ENTER works fine if I am typing text. Have tried it in the formulas,
but to no avail.

=CONCATENATE(MasterList!A$3,CHAR(10),MasterList!C$3)

=MasterList!A$3
&
CHAR(10)
&
MasterList!C$3

and
=MasterList!A$3&CHAR(10)&MasterList!C$3

all return the little square.

Thank you in advance

 

[Cummings]

EXCEL 2003. sorry

 

[Billy Liddel]

Hi, Just format the cells, Format, Cells, Alignment, Wrap Text, OK
And then the char(10) will be recognised.

Peter

 

[Cummings]

ARGHH!!!!!!!!!!!!!!!!!!

Thanks. You know, sometimes it would be really nice if these things were
mentioned on the program's help page.

But then, you wouldn't get paid.

But you don't.

Thank you from the bottom of my heart for the answer to this and countless
other stupid questions I've asked over the years.

Jim