| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
Thanks Claus. Sometimes the obvious escapes me.
|
| Reply |
| 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 | |||
Linear Mode
