a1单元数为a+b+c+d用excel公式按+号分成a b c d 要以A1为计算基础

可以使用以下公式：

a: =LEFT(A1,FIND("+",A1)-1) b: =MID(A1,FIND("+",A1)+1,FIND("+",A1,FIND("+",A1)+1)-FIND("+",A1)-1) c: =MID(A1,FIND("+",A1,FIND("+",A1)+1)+1,FIND("+",A1,FIND("+",A1,FIND("+",A1)+1)+1)-FIND("+",A1,FIND("+",A1)+1)-1) d: =RIGHT(A1,LEN(A1)-FIND("+",A1,FIND("+",A1,FIND("+",A1)+1)+1))