WPS里的excel表格怎么把数字提取出来再继续运算?

2025-04-14 03:18:14
推荐回答(1个)
回答1:

可用公式:

B1=SUMPRODUCT(TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"片",""),"件",REPT(" ",9)),{1,10},10))*{2,0.8})

下拉。