請教公式, 掫取句子某文字. 謝謝幫忙

高个子 · 发表于 2024-6-16 21:14

=FILTERXML(SUBSTITUTE("<a>"&TEXTJOIN(",",1,LET(x,FILTERXML(SUBSTITUTE("<a>"&SUBSTITUTE(SUBSTITUTE(A1,"次",","),"課","")&"</a>",",","" ),"a/b"),MID(FILTER(x,LEFT(x)<>"。"),3,99)),MID(A1,FIND("。",A1)+1,99))&"</a>",",","" ),"a/b")

复制代码

cnmlgb9998 · 发表于 2024-6-16 22:37

借楼练一下 PQ。

是这个效果吗？ PQ难道不香吗？？？？？

ggmmlol · 发表于 2024-6-17 00:26

=REGEXEXTRACT(A1,"\d+(?=.*。)|(?<=。).+",1)

复制代码

hcm19522 · 发表于 2024-6-17 16:22

A3=IFERROR(-LOOKUP(1,-RIGHT(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A$1&"#課,","。",),"次","課,"),"課,",REPT(" ",99)),ROW(A1)*99-98,99),ROW($1:$99))),IF(A2="","",SUBSTITUTE(MID(A$1,FIND("。",A$1)+1,99),A2,)))

龙逸凡 · 发表于 2024-6-17 17:29

=TOCOL(TEXTSPLIT(A1,TEXTSPLIT(LEFT(A1,FIND("。",A1)),ROW(1:10)-1,,1),,1),0)

		自动登录	找回密码
密码			免费注册

[求助] 請教公式, 掫取句子某文字. 謝謝幫忙