On Jun 9, 3:31 pm, Dave wrote:
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

Just for fun:
=IF(OR(ISBLANK(E27:E30)),"","C"&E27&E28&E29&E30)
Use CTRL-SHIFT-ENTER since it is an array.