如何在excel改公式
可改为:
=VALUE(LEFT(TRIM(RIGHT(SUBSTITUTE(A2,"元"," "),LEN(A2)-(FIND("付款",A2)+1)))&" ",FIND(" ",TRIM(RIGHT(SUBSTITUTE(A2,"元"," "),LEN(A2)-(FIND("付款",A2)+1)))&" ")-1))
热门标签:
可改为:
=VALUE(LEFT(TRIM(RIGHT(SUBSTITUTE(A2,"元"," "),LEN(A2)-(FIND("付款",A2)+1)))&" ",FIND(" ",TRIM(RIGHT(SUBSTITUTE(A2,"元"," "),LEN(A2)-(FIND("付款",A2)+1)))&" ")-1))