Hard return in concatenate

[pamp]

How do I enter a hard return between two fields I concatenate?

 

[Pete_UK]

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

 

[Dave Peterson]

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.

 

[Khoshravan]

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

 

[Ashish Mathur]

Hi,

You will have to wrap text (from Format cells)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Rasoul Khoshravan]

Hi,

You will have to wrap text (from Format cells)

--
Regards,

Ashish Mathur
Microsoft Excel MVPwww.ashishmathur.com

Thanks. That was a point missed on replies.