WPS中如何让字符串中的数值分别乘以指定值

1、点击D2单元格，输入：=TEXTJOIN("/",,TRIM(MID(SUBSTITUTE(B2,"/",REPT(" ",100)),{1,2,3}*100-99,20))*C2)，按enter键结束

2、点击D2单元格，下拉完成公式填充

3、公式讲解。TRIM(MID(SUBSTITUTE(B2,"/",REPT(" ",100)),{1,2,3}*100-99,20))返回{"1","20","50"}

4、TEXTJOIN("/",,{"1","20","50"}*C2)返回"2/40/100"

TEXTJOIN函数使用分隔符/连接列表或文本字符串区域