inserting hard CR in a formula

BusinessEngineer

inserting hard CR in a formula

Excel455
I am trying to write a formula to combine the contents of 3 cells into one

cell with a hard CR between each cell. Any ideas?

Thanks,

Rick

-

PCLIVE

Registered User

Wed Nov 08 10:51:09 CST 2006

Re:inserting hard CR in a formula

=A1 & CHAR(10) & A2 & CHAR(10) & A3

You will need to format the cell to wrap.

Regards,

Paul

"Rick Morrison" <rlmorrison@earthlink.net>wrote in message

Quote

I am trying to write a formula to combine the contents of 3 cells into one

cell with a hard CR between each cell. Any ideas?

Thanks,

Rick