你好如何在EXCEL里更改数字

更新时间2018-12-20 11:17:39

把最后一次的公式中的"付款"改为"收款"即可。

=VALUE(LEFT(TRIM(RIGHT(SUBSTITUTE(A2,"元"," "),LEN(A2)-(FIND("收款",A2)+1)))&" ",FIND(" ",TRIM(RIGHT(SUBSTITUTE(A2,"元"," "),LEN(A2)-(FIND("收款",A2)+1)))&" ")-1))