inserting hard CR in a formula
 

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

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" wrote in message
...
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