=CONCATENATE(A2," ", B2," ", C2," ", G2,CHAR(10),I2," ", J2,
CHAR(10),L2,CHAR(10), M2," ", O2, CHAR(10), P2, CHAR(10), Q2, " ",R2)

When I copy this information to a new worksheet, the information just comes
out as #REF! and the above formula appears with all #REF! in it. I have the
column width wide enough.