....CONCATENATE(A1:D1)

That won't work. CONCATENATE won't work on arrays. You'd have to do this:

.....CONCATENATE(A1,B1,C1,D1)

Saves a few keystrokes if you do it like this:

.....A1&B1&C1&D1

--
Biff
Microsoft Excel MVP


"Dave" wrote in message
...
Hi,
Not sure if I'm on the right track, but if you are concatenating Cells A1,
B1, C1, D1, all into E1, perhape something like:
IF(COUNTA(A1:D1)=4,CONCATENATE(A1:D1),"")
or some other use of COUNTA to check that all contributing cells have
data.
Regards - Dave.