紧急，请各位大神帮忙看下有没有什么快捷的办法

溪边小径

请各位大神帮忙看下有没有什么快捷的办法

leepoison

1. =DROP(REDUCE("",A2:L2,LAMBDA(x,y,VSTACK(x,VSTACK(IFNA(VSTACK(TRANSPOSE(TEXTBEFORE(y,"(")&ROW(INDIRECT(SUBSTITUTES(TEXTAFTER(TEXTBEFORE(y,")"),"("),"-",":")))&"-"),OFFSET(y,1,0)),OFFSET(y,1,0)))))),1)

复制代码

theking_wsz

=DROP(DROP(REDUCE("",A2:L2,LAMBDA(x,y,VSTACK(x,REDUCE("",SEQUENCE(,8)-1,LAMBDA(a,b,HSTACK(a,VSTACK(REGEXP(y,"\(.*?\)",2,b+REGEXP(y,"\(\K\d")),OFFSET(y,1,)))))))),1),,1)

博爱风雨同舟

A6=LET(S,OFFSET($A$1,MOD(ROW(2:2),2)+1,INT(ROW(2:2)/2)-1),EXPAND(S,,8,S))
往下拉即可

溪边小径

leepoison 发表于 2024-10-10 18:54

可不可以1-16在一行

leepoison

溪边小径 发表于 2024-10-10 11:48
可不可以1-16在一行

1. =LET(a,DROP(REDUCE("",A2:L2,LAMBDA(x,y,VSTACK(x,VSTACK(IFNA(VSTACK(TRANSPOSE(TEXTBEFORE(y,"(")&ROW(INDIRECT(SUBSTITUTES(TEXTAFTER(TEXTBEFORE(y,")"),"("),"-",":")))&"-"),OFFSET(y,1,0)),OFFSET(y,1,0)))))),1),HSTACK(CHOOSEROWS(a,TOCOL(4*SEQUENCE(6)-{3,2})),CHOOSEROWS(a,TOCOL(4*SEQUENCE(6)-{1,0}))))

复制代码

quqiyuan

这个用来练习了一下正则查找，替换，挺好的。。。

飞天篮球猪

仅供参考...

一杯绿茶来了

=DROP(REDUCE("",A2:L2,LAMBDA(x,y,VSTACK(x,LET(s,TEXTBEFORE(y,"-",2)&"-",a,TEXTAFTER(y,"-",2),b,CLEAN(TRIM(SUBSTITUTE(SUBSTITUTE(LEFT(a,LEN(a)-1),"(",),")",))),IFNA(VSTACK(TOROW(s&CHAR(10)&ROW(INDIRECT(SUBSTITUTE(b,"-",":")))&"-"),OFFSET(y,1,)),OFFSET(y,1,)))))),1)

mykitami

=DROP(REDUCE("",A2:L2,LAMBDA(x,y,VSTACK(x,TRANSPOSE(IF({1,0},TEXTBEFORE(y,"(")&ROW(INDIRECT(SUBSTITUTE(TEXTBEFORE(TEXTAFTER(y,"("),")"),"-",":")))&"-",OFFSET(y,1,)))))),1)