公式有点长。示例文件：https://cowtransfer.com/s/25ec5988058d4c B2=MID(A2,FIND("/",SUBSTITUTE(A2,"+","@",2),1)+1,IF(IFERROR(VALUE(MID(A2,FIND("@",SUBSTITUTE(A2,"+","@",2),1)+7,1)),11)<10,FIND("@",SUBSTITUTE(A2,"+","@",2),1)+7,IF(IFERROR(VALUE(MID(A2,FIND("@",SUBSTITUTE(A2,"+","@",2),1)+6,1)),11)<10,FIND("@",SUBSTITUTE(A2,"+","@",2),1)+6,FIND("@",SUBSTITUTE(A2,"+","@",2),1)+5))-FIND("/",SUBSTITUTE(A2,"+","@",2),1))
