| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL 2003: how to add CR or alt-enter using CONCATINATE function
i am trying to insert a carriage return or alt-enter in a cell in the
CONCATINATE function. CONCATINATE(a1, "-", b1, "(enter)") where enter is the symbol i need to use. do not know what it is so it will force an CR or alt-enter. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
EXCEL 2003: how to add CR or alt-enter using CONCATINATE function
char(10)
=concatenate(a1,"-",b1,char(10)) or =a1&"-"&b1&char(10) MRHenn wrote: i am trying to insert a carriage return or alt-enter in a cell in the CONCATINATE function. CONCATINATE(a1, "-", b1, "(enter)") where enter is the symbol i need to use. do not know what it is so it will force an CR or alt-enter. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 cannot enter product key!! | Excel Discussion (Misc queries) | |||
| alt+enter is not working in excel 2003. | Excel Discussion (Misc queries) | |||
| Concatinate a function and make it work | Excel Discussion (Misc queries) | |||
| Not able to enter [ in Excel 2003 | Excel Discussion (Misc queries) | |||
| Cannot enter numbers in Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
