Enter carriage return in Excel 2010 text string
 

I am trying to input a text string with a carriage return or break so the second part shows on a separate line. Other threads have demonstrated the use of CHAR(10) but that is not working for me. Here is my code:
=K2&CHAR(10)&" "&TEXT(C2,"mm/dd/yyyy")&" @ "&D2

Anyone have any ideas what I need to change to get it to work properly?

Enter carriage return in Excel 2010 text string
 

Hi,

Am Tue, 31 Dec 2013 14:37:41 +0000 schrieb LoydC:

=K2&CHAR(10)&" "&TEXT(C2,"mm/dd/yyyy")&" @ "&D2

right click in your cell = Format cells = Alignment = Wrap Text [x]

Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Thanks Claus. Sometimes the obvious escapes me.