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.