请教老师一个拆分问题

ifan0916

1. =SUBSTITUTE(TRIM(MID(SUBSTITUTE(SUBSTITUTE($A$1,":",";"),";",REPT(" ",99)),ROW(A1)*99-98,99)),G5,)

复制代码

1. =IFERROR(-LOOKUP(,-RIGHT(TRIM(MID(SUBSTITUTE(SUBSTITUTE($A$1,":",";"),";",REPT(" ",99)),ROW(A1)*99-98,99)),ROW($1:$15))),"")

复制代码

我的城市你来过

=LET(x,TOCOL(TEXTSPLIT($A$1,";",":"),3),HSTACK(MIDB(x,1,IFERROR(SEARCHB("?",x)-1,LENB(x))),TRIM(MIDB(x,IFERROR(SEARCHB("?",x),LENB(x)),66))))

菜狗一只

1. =LET(Y,LET(X,TEXTSPLIT(A1,,{":",";"}),MID(X,1,LENB(X)-LEN(X))),HSTACK(Y,RIGHT(TEXTSPLIT(A1,,{":",";"}),LEN(TEXTSPLIT(A1,,{":",";"}))-LEN(Y))))

复制代码

hugeinfo

=TAKE(TEXTSPLIT(A1,ROW($1:$10)-1,{":",";"}),,1)


=TAKE(TEXTSPLIT(A1,F5:F11,{":",";"}),,-1)

世界客都

魚。。 发表于 2024-3-28 12:26
新版wps连let都有了呀？不得了

俊哥，其实let很早就有了
一会儿4月1号的新版本更加多新函数

Excel地板砖

1. =SUBSTITUTE(TRIM(MID(SUBSTITUTE(SUBSTITUTE($A$1,":",";"),";",REPT(" ",100)),ROW(A1)*100-99,99)),H5,)

复制代码

=IFERROR(-LOOKUP(,-RIGHT(TRIM(MID(SUBSTITUTE(SUBSTITUTE($A$1,":",";"),";",REPT(" ",100)),ROW(A1)*100-99,99)),ROW($1:$15))),"")

Excel地板砖

魚。。

世界客都 发表于 2024-3-28 20:49
俊哥，其实let很早就有了
一会儿4月1号的新版本更加多新函数

WPS未来可期呀，哈哈

世界客都

魚。。 发表于 2024-3-28 22:47
WPS未来可期呀，哈哈

总要跟上脚步的

mykitami

=LET(a,TEXTSPLIT(A1,,{":",";"},1),b,IFNA(BYROW(a,LAMBDA(x,-LOOKUP(,-RIGHT(x,SEQUENCE(99))))),""),HSTACK(SUBSTITUTE(a,b,),b))