| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Carriage return in same cell without using alt-enter | Excel Worksheet Functions | |||
| Text String (Edit w/Carriage Return) | Excel Programming | |||
| Alt+enter to carriage return within a cell does not work...? | Excel Discussion (Misc queries) | |||
| Carriage Return / ALT-Enter in Textbox control | Excel Programming | |||
| Carriage Return / ALT-Enter in Textbox control | Excel Programming | |||
Threaded Mode
