"Seldonian Crisis" wrote in
message ...
I've got to concatenate 416 cells within a row, the resulting text also
needs
to be split by commas . do i have to manually write out
CONCATENATE(A1,CHAR(44),B1,CHAR(44),C1... etc or is there a way of
speeding
this up?

I think you will run into several problems doing this. I would use an
iterative approach:
In B1 put the formula =A1
In B2 put the formula =A2&","&B1
Copy this latter formula across row 2 as far as you need.