| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hard return in concatenate
How do I enter a hard return between two fields I concatenate?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hard return in concatenate
Like this:
=A1 & CHAR(10) & B1 CHAR(10) is the linefeed character (equivalent to Alt-Enter when you do it manually). Hope this helps. Pete On Feb 6, 1:08*am, wrote: How do I enter a hard return between two fields I concatenate? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hard return in concatenate
As a formula:
=a1&char(10)&"This is the second line"&char(10)&text(b1,"$#,##0.00") (and format the cell for wraptext--or you'll see a little box for that char(10).) As input, you hit alt-enter to force a new line within the cell. in code: dim myStr as string mystr = "Something" & vbnewline & "something else" & vblf & "a third thing" vbnewline will work for both Mac's and PC's. vbLf is enough for PC's. wrote: How do I enter a hard return between two fields I concatenate? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hard return in concatenate
A1=Apple B1=Orange
I was expecting by this formula to get: Apple Orange (In two lines in a cell) But I get: AppleOrange Char(10) didn't work for me. I am using Excel 2003 -- R. Khoshravan Please click "Yes" if it is helpful. "Pete_UK" wrote: Like this: =A1 & CHAR(10) & B1 CHAR(10) is the linefeed character (equivalent to Alt-Enter when you do it manually). Hope this helps. Pete On Feb 6, 1:08 am, wrote: How do I enter a hard return between two fields I concatenate? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hard return in concatenate
Hi,
You will have to wrap text (from Format cells) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Khoshravan" wrote in message ... A1=Apple B1=Orange I was expecting by this formula to get: Apple Orange (In two lines in a cell) But I get: AppleOrange Char(10) didn't work for me. I am using Excel 2003 -- R. Khoshravan Please click "Yes" if it is helpful. "Pete_UK" wrote: Like this: =A1 & CHAR(10) & B1 CHAR(10) is the linefeed character (equivalent to Alt-Enter when you do it manually). Hope this helps. Pete On Feb 6, 1:08 am, wrote: How do I enter a hard return between two fields I concatenate? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hard return in concatenate
On Feb 6, 11:52*am, "Ashish Mathur" wrote:
Hi, You will have to wrap text (from Format cells) -- Regards, Ashish Mathur Microsoft Excel MVPwww.ashishmathur.com "Khoshravan" wrote in message ... A1=Apple B1=Orange I was expecting by this formula to get: Apple Orange (In two lines in a cell) But I get: AppleOrange Char(10) didn't work for me. I am using Excel 2003 -- R. Khoshravan Please click "Yes" if it is helpful. "Pete_UK" wrote: Like this: =A1 & CHAR(10) & B1 CHAR(10) is the linefeed character (equivalent to Alt-Enter when you do it manually). Hope this helps. Pete On Feb 6, 1:08 am, wrote: How do I enter a hard return between two fields I concatenate? Thanks. That was a point missed on replies. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert a hard return in a =CONCATENATE formula in excel | Excel Worksheet Functions | |||
| Hard return | Excel Worksheet Functions | |||
| HARD RETURN IN A CELL | Excel Discussion (Misc queries) | |||
| Replace ; with hard return | Excel Discussion (Misc queries) | |||
| hard return | New Users to Excel | |||
Linear Mode
