Concatenation

N

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.
 
N

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.
 
S

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?
 
M

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
 
Top