=(D1;" ";((E1);"";(E1;"! "));C1;" ";((F1);"";(F1;" ."));" ";((G1);"";(" ";(G1;".."))))

ZSMSCellExample1.xls


=(($D$1;"#1";B3); "#2"; C3)

ZSMSCellExample2.xls