execl表格中数字加减方法

需要用到辅助单元格；在单元格K3录入公式：=MID(TRIM(SUBSTITUTE(H3,""," "))&" ",FIND("*",SUBSTITUTE(TRIM(SUBSTITUTE(H3,""," "))&" ","-","*",1))+1,FIND("**",SUBSTITUTE(TRIM(SUBSTITUTE(H3,""," "))&" "," ","**",1))-FIND("*",SUBSTITUTE(TRIM(SUBSTITUTE(H3,""," "))&" ","-","*",1)))-MID(TRIM(SUBSTITUTE(I3,""," "))&" ",FIND("*",SUBSTITUTE(TRIM(SUBSTITUTE(I3,""," "))&" ","-","*",1))+1,FIND("**",SUBSTITUTE(TRIM(SUBSTITUTE(I3,""," "))&" "," ","**",1))-FIND("*",SUBSTITUTE(TRIM(SUBSTITUTE(I3,""," "))&" ","-","*",1)))在单元格L3录入相似的公式，只是将上述公式中的6个1改为2；在单元格M3录入相似的公式，只是将上述公式中的6个1改为3；在单元格J3录入公式：=K3&""&L3&""&M3选取J3-M3，下拉复制即可。注意：上述2公式中分别有8/2处换了行的地方是"换行符号"，只需复制粘贴即可。