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.

Char(10)

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

"Nanapat" wrote:

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: 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" wrote:

Char(10)

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

"Nanapat" wrote:

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.

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?



"Nanapat" wrote:

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" wrote:

Char(10)

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

"Nanapat" wrote:

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.

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
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"Nanapat" wrote:

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.