=RIGHT(SUBSTITUTE(LEFT(B2,FIND("，",B2)-1),"元",""),2*LEN(SUBSTITUTE(LEFT(B2,FIND("，",B2)-1),"元",""))-LENB(SUBSTITUTE(LEFT(B2,FIND("，",B2)-1),"元","")))+RIGHT(SUBSTITUTE(RIGHT(B2,LEN(B2)-FIND("，",B2)),"元",""),2*LEN(SUBSTITUTE(RIGHT(B2,LEN(B2)-FIND("，",B2)),"元",""))-LENB(SUBSTITUTE(RIGHT(B2,LEN(B2)-FIND("，",B2)),"元","")))
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024