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

如果单元数为a+b+c+d，则可以使用以下公式：

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

如果单元数为a+b+c，则可以使用以下公式：

=LEFT(A1,FIND("+",A1)-1) //取得a =MID(A1,FIND("+",A1)+1,FIND("+",A1,FIND("+",A1)+1)-FIND("+",A1)-1) //取得b =RIGHT(A1,LEN(A1)-FIND("+",A1,FIND("+",A1)+1)) //取得c