| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you force a new line in a formula in Excel?
I'm trying to use the CONCATENATE function but I also want to force a
'return' in the function/formula as if entering data into a cell and using ALT+ENTER to force a new line. Can this be done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you force a new line in a formula in Excel?
You can use CHAR(10) in your Concatenate function, like this:
=CONCATENATE("First line",CHAR(10),"Second line") You also need to format the cell to allow text wrapping, or the linefeed character will appear as a little square box. Hope this helps, Hutch "JeffRI" wrote: I'm trying to use the CONCATENATE function but I also want to force a 'return' in the function/formula as if entering data into a cell and using ALT+ENTER to force a new line. Can this be done? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you force a new line in a formula in Excel?
This was awesome!! Thx for the info! That's exactly what I was looking for.
"Tom Hutchins" wrote: You can use CHAR(10) in your Concatenate function, like this: =CONCATENATE("First line",CHAR(10),"Second line") You also need to format the cell to allow text wrapping, or the linefeed character will appear as a little square box. Hope this helps, Hutch "JeffRI" wrote: I'm trying to use the CONCATENATE function but I also want to force a 'return' in the function/formula as if entering data into a cell and using ALT+ENTER to force a new line. Can this be done? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you force a new line in a formula in Excel?
You can also use ="Line1" & CHAR(10) & "Line2"
CONCATENATE is such a long way of saying &. You must format the cell to wrap text. Tyro "JeffRI" wrote in message ... I'm trying to use the CONCATENATE function but I also want to force a 'return' in the function/formula as if entering data into a cell and using ALT+ENTER to force a new line. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I force a line chart to not plot cells that are "null". | Charts and Charting in Excel | |||
| concatenate, force new line | Excel Worksheet Functions | |||
| How to force continuous lines in line charts | Charts and Charting in Excel | |||
| How do I force a series in a Bar-Line Chart to be a Bar? | Charts and Charting in Excel | |||
Linear Mode
