EXCEL 2003: how to add CR or alt-enter using CONCATINATE function

[Guest]

i am trying to insert a carriage return or alt-enter in a cell in the
CONCATINATE function. CONCATINATE(a1, "-", b1, "(enter)") where enter is
the symbol i need to use. do not know what it is so it will force an CR or
alt-enter.

 

[Dave Peterson]

char(10)

=concatenate(a1,"-",b1,char(10))
or
=a1&"-"&b1&char(10)