=LET(jPart, IF(J2<>"", J1&J2&"+", ""),kPart, IF(K2<>"", K1&K2&"+", ""),lPart, IF(L2<>"", L1&L2, ""),result, CONCATENATE(jPart, kPart, lPart),IF(RIGHT(result)="+", LEFT(result, LEN(result)-1), result))
如果你的excel连LET都不支持的话就用下面这个吧,不过建议之后可以升级版本了
=MID(CONCATENATE(IF(J2<>"", $J$1&J2&"+", ""),IF(K2<>"", $K$1&K2&"+", ""),IF(L2<>"", $L$1&L2, "")),1,LEN(CONCATENATE(IF(J2<>"", $J$1&J2&"+", ""),IF(K2<>"", $K$1&K2&"+", ""),IF(L2<>"", $L$1&L2, ""))) - IF(RIGHT(CONCATENATE(IF(J2<>"", $J$1&J2&"+", ""),IF(K2<>"", $K$1&K2&"+", ""),IF(L2<>"", $L$1&L2, ""))) = "+", 1, 0))
|