急WPS表格中有文字也有数字，要相加数字怎么加？

如何查找单元格里面带文字的值相加,要求没办法拆分格，求大神帮忙！

=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)),"元","")))