我认为文字合并功能并非函数的特长。
如果一定要用函数实现,只能用逐个判断并连接在一起的笨办法,且公式很长。
P2公式:
=MID(IF(A2,TEXT(A$1,"+m-d")&"*"&A2,)&IF(B2,TEXT(B$1,"+m-d")&"*"&B2,)&IF(C2,TEXT(C$1,"+m-d")&"*"&C2,)&IF(D2,TEXT(D$1,"+m-d")&"*"&D2,)&IF(E2,TEXT(E$1,"+m-d")&"*"&E2,)&IF(F2,TEXT(F$1,"+m-d")&"*"&F2,)&IF(G2,TEXT(G$1,"+m-d")&"*"&G2,)&IF(H2,TEXT(H$1,"+m-d")&"*"&H2,)&IF(I2,TEXT(I$1,"+m-d")&"*"&I2,)&IF(J2,TEXT(J$1,"+m-d")&"*"&J2,)&IF(K2,TEXT(K$1,"+m-d")&"*"&K2,)&IF(L2,TEXT(L$1,"+m-d")&"*"&L2,)&IF(M2,TEXT(M$1,"+m-d")&"*"&M2,)&IF(N2,TEXT(N$1,"+m-d")&"*"&N2,)&IF(O2,TEXT(O$1,"+m-d")&"*"&O2,),2,200)
将公式向下复制。