It would have helped if you would've posted your formula.

So, my best guess is:

=IF(COUNTA(A1:D1)<4,"","C"&A1&B1&C1&D1)


--
Biff
Microsoft Excel MVP


"Dave" wrote in message
...
Is there a way to have a constant not appear in a concatenation cell until
the full number of cells in the concatenation are completed?

What I'm trying to do is create a concatenation of several cells to come
up
with a part description. In this case, it's for a cable. The cables can
have several (many)conductors, and part of the description calls for the
conductor segment to have a "C" before the number of conductors.

Everything works fine, but it seems silly to have a validation for one
value
("C"). I can do this, and I have also included a "C" in the concatenation
formula. Only problem is, this way the "C" shows up in the concatenation
cell before the other values are established. This isn't really 'elegant'

Thanks,

Dave