求大神指导excell函数提取字符串中多组两特定字符间的数值并求和100答:如果是excel365版本,公式参考如下:=LET(m,MAP(TAKE(TEXTSPLIT(B2,":",";",1),,-1),LAMBDA(x,-LOOKUP(1,-LEFT(x,SEQUENCE(LEN(x))),HSTACK(TEXTJOIN("+",,m),SUM(m)))结果如下图所示:
excel第一列中人名减去第二列中人名剩余的显示在第三列?答:=TEXTJOIN(",",,IFERROR(MAP(TEXTSPLIT(A2,TEXTSPLIT(B2,","),),LAMBDA(x,TEXTJOIN(",",,TEXTSPLIT(x,,","))),""))或者 =REDUCE(A2&",",TEXTSPLIT(B2,",",)&",",LAMBDA(x,y,SUBSTITUTE(x,y,)))