Ingenious Rick, but it doesn't grab the code names from row 2.

Not so ingenious then, was it. <g

This formula, considerably longer, should work...

=SUBSTITUTE(SUBSTITUTE(TRIM(B3&"-"&LEFT(D$2,9*(D3="X"))&" "&LEFT(E$2,9*
(E3="X"))&" "&LEFT(F$2,9*(F3="X"))&" "&LEFT(G$2,9*(G3="X"))&" "&LEFT(
H$2,9*(H3="X"))&" "&LEFT(I$2,9*(I3="X"))&" "&LEFT(J$2,9*(J3="X"))&" "&
LEFT(K$2,9*(K3="X"))&" "&LEFT(L$2,9*(L3="X"))&" "&LEFT(M$2,9*(M3="X"))&
" "&LEFT(N$2,9*(N3="X"))&" "&LEFT(O$2,9*(O3="X"))&" "&LEFT(P$2,9*(P3="X"))&
" "&LEFT(Q$2,9*(Q3="X"))&" "&LEFT(R$2,9*(R3="X"))&" "&LEFT(S$2,9*(S3="X"))&
" "&LEFT(T$2,9*(T3="X"))&" "&LEFT(U$2,9*(U3="X"))&" "&LEFT(V$2,9*(V3="X"))&
" "&LEFT(W$2,9*(W3="X"))&" "&LEFT(X$2,9*(X3="X"))&" "&LEFT(Y$2,9*(Y3="X"))&
" "&LEFT(Z$2,9*(Z3="X"))&" "&LEFT(AA$2,9*(AA3="X"))&" "&LEFT(AB$2,9*(
AB3="X"))&" "&LEFT(AC$2,9*(AC3="X")))," ","/"),"-/","-")

Rick Rothstein (MVP - Excel)