| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Concatenate and Line Breaks
Hi,
Normally, we can use Alt+Enter to add a line break to text we type into a single cell. Is something like this possible with the concatenate function? I'd like to take texts from several different cells and put them together in one cell with line breaks where I want them. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenate and Line Breaks
=CONCATENATE(A1,CHAR(10),A2)
and then format the cell to wrap -- Gary's Student "Invoice" wrote: Hi, Normally, we can use Alt+Enter to add a line break to text we type into a single cell. Is something like this possible with the concatenate function? I'd like to take texts from several different cells and put them together in one cell with line breaks where I want them. -- Invoice |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a formula to create a new line of text in a cell? | Excel Worksheet Functions | |||
| Creating a concatenate text list by referencing an array | Excel Discussion (Misc queries) | |||
| Using concatenate to include a line return | Excel Discussion (Misc queries) | |||
| concatenate, force new line | Excel Worksheet Functions | |||
| How do I insert a line break when using the CONCATENATE function? | Excel Worksheet Functions | |||
Linear Mode
