运算效果图如下:
B2单元格输入公式:
=EVALUATE(LEFT(A2,FIND("+",A2)-1))&"+"&EVALUATE(MID(A2,FIND("+",A2)+1,FIND("@",SUBSTITUTE(A2,"+","@",2))-FIND("+",A2)-1))&"+"&EVALUATE(RIGHT(A2,LEN(A2)-FIND("+",SUBSTITUTE(A2,"+","@",1))))
C2单元格输入公式:
=EVALUATE(A2)
再下拉B2,C2单元格就可以了
如本站内容“对您有用”,欢迎随意打赏,让我们持续更新!