excel中如何将每个表格中+号前和加号后的数字分别相加?如A1=3+5...答:=left(a1,find("+",a1)-1)+left(b3,find("+",b3)-1)+right(a1,len(a1)-find("+",a1))+right(b3,len(b3)-find("+",b3))分解一下公式 =left(a1,find("+",a1)-1) A1的加号前的数 =left(b3,find("+",b3)-1) B3的加号前的数 =right(a1,len(a1)-find("+",a1...