WPS中如何让字符串中的数值分别乘以指定值
1、点击D2单元格,输入:=TEXTJOIN("/",,TRIM(MID(SUBSTITUTE(B2,"/",REPT(" ",100)),{1,2,3}*100-99,20))*C2),按enter键结束

3、公式讲解。TRIM(MID猾诮沓靥(SUBSTITUTE(B2,"/",REPT(" ",100)),{1,2,3}*100-99,20))返回{媪青怍牙"1","20","50"}

1、点击D2单元格,输入:=TEXTJOIN("/",,TRIM(MID(SUBSTITUTE(B2,"/",REPT(" ",100)),{1,2,3}*100-99,20))*C2),按enter键结束
3、公式讲解。TRIM(MID猾诮沓靥(SUBSTITUTE(B2,"/",REPT(" ",100)),{1,2,3}*100-99,20))返回{媪青怍牙"1","20","50"}