inserting hard CR in a formula

R

Rick Morrison

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
 
P

PCLIVE

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

You will need to format the cell to wrap.

Regards,
Paul
 
Top