When I copy this *information* to a new worksheet

Apparently they meant:

When I copy this formula to a new worksheet

I guess I gotta quit interpreting posts so literally!

Biff

"Duke Carey" wrote in message
...
The error suggests that when you paste it into the new worksheet you are
changing the relative references so that at least one of them refers to a
cell outside the sheet's boundaries. Here you are referencing row 2. If
the
original formula was in row 10 and you are pasting it into row 9 on the
new
sheet, all the row references would now be changed to row 1. *BUT*, if
you
copy it into anything above row 9 the row references get changed to 0 or
negative #s, which Excel will reject with the #Ref


"Terri" wrote:

=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.