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
--
JP Cummings