View Single Post
  #1   Report Post  
LoydC LoydC is offline
Junior Member
 
Posts: 2
Default 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?