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?
|