求助大神提取

ssg365

EXCEL2021 发表于 2020-5-13 14:24
感谢，e1 f1是怎么实现的？

同一公式，向右向下扩展即可。

EXCEL2021

ssg365 发表于 2020-5-13 14:33
同一公式，向右向下扩展即可。

感谢，好的

EXCEL2021

ssg365 发表于 2020-5-13 14:33
同一公式，向右向下扩展即可。

我这儿没反应，麻烦看看我抄的对不=TRIM(MID(SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,"【",""),"】",""),"/","")),"",REPT("",100)),COLUMN(A1)*100-99,100))

hcm19522

C2:C7=LOOKUP(9^9,LEFT(A2,ROW($1:$10))*1)

D2:D7=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,"【"," ")," ",REPT(" ",99)),99,99))

E2:G7=TRIM(MID(SUBSTITUTE(SUBSTITUTE(MID($A2,FIND("【",$A2)+1,99),"】",),"/",REPT(" ",99)),COLUMN(A1)*99-98,99))

ssg365

不是"" 是" "

EXCEL2021

hcm19522 发表于 2020-5-13 15:13
C2:C7=LOOKUP(9^9,LEFT(A2,ROW($1:$10))*1)

D2:D7=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,"【"," ")," ",RE ...

好的，感谢

EXCEL2021

ssg365 发表于 2020-5-13 15:13
不是"" 是" "

明白，感谢