"Robin Gray" wrote in
:

I now need to copy this down 3000 rows but when I copy the cell C1 to
C2 I get exactly the same formula in C2.
I expected it to change to =concatenate(A2," ",B2)


When you select C1 you'll see a tiny square at the bottom right corner.
Drag that down to copy the formula.

Did it work?


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)