求大神指点分列公式：把括号里尺码段用/隔开的每个值取到B至F列黄色单元格内哈

lz79206966

求大神指点分列公式：把括号里尺码段用/隔开的每个值取到B至F列黄色单元格内哈


求分解公式.zip (8.87 KB, 下载次数: 16)

2023-5-17 11:12 上传

点击文件名下载附件

theking_wsz

=TEXTSPLIT(SUBSTITUTE(TEXTAFTER(SUBSTITUTE(SUBSTITUTE(A2,"(","（"),")","）"),"（"),"）",""),"/")   括号不统一  多了几个SUBSTITUTE

minchar

=DROP(TEXTSPLIT(A2,{"(",")","（","）","/"},,1),,1)

my0745

1. B2=TRIM(MID(SUBSTITUTE(SUBSTITUTE(MID(SUBSTITUTE(SUBSTITUTE($A2,"（","("),"）",")"),FIND("(",SUBSTITUTE(SUBSTITUTE($A2,"（","("),"）",")"))+1,100),")",""),"/",REPT(" ",100)),(COLUMN(A$1)-1)*100+1,100))

复制代码

来个低版本的。向右拉、向下拉。

橒♂蝣

B2右拉下拉=TRIM(MID(SUBSTITUTE(MID($A2,FIND("(",$A2)+1,FIND(")",$A2)-FIND("(",$A2)-1),"/",REPT(" ",99)),COLUMN(A1)*99-98,99))

lz79206966

橒♂蝣 发表于 2023-5-17 17:07
B2右拉下拉=TRIM(MID(SUBSTITUTE(MID($A2,FIND("(",$A2)+1,FIND(")",$A2)-FIND("(",$A2)-1),"/",REPT(" ",9 ...

你好，这个公式不好用，只有第1个好用，其它的都是乱码