Concatenation

[Nanapat]

I want to concatenate with a "hard return". Using the formula:

=concatenate(A1," ",B1)

what would I use between the parentheses to insert a hard return? Thank you
so much.

 

[Sheeloo]

Char(10)

=concatenate(A1,Char(10),B1)

 

[Nanapat]

Sheeloo: This didn't put a hard return in between cells A1 and B1 when
concatenation occurred. Maybe the character code is different on my computer.

 

[Sheeloo]

This will put A1 and B1 on separate lines in the same cell...
I forgot to add that you will have to format the cell with WORD WRAP.

If that does not work then can you pl. explain what you mean by hard return?

 

[MikeJohnB]

Try:

=A1&Char(10)&B1

Will give the following results

A1= Try B1= this

Try
This (In one cell)

Concatenate works except it doesn't translate the Char(10) but leaves the
sign for a hard return