多个数字提取

E花E世界 · 发表于 2024-5-6 17:28

=SUBSTITUTES(A2,{"（T)";"（L)";"(W)mm"})

复制代码

魚。。 · 发表于 2024-5-6 17:46

=REGEXP(A2,"[^0-9.*]",2)

复制代码

静听溪流 · 发表于 2024-5-6 17:53

CTRL+E

静听溪流 · 发表于 2024-5-6 17:57

=LEFT(FILTERXML("<a>"&SUBSTITUTE(SUBSTITUTE(ASC(A2),"(","<b>"),")","</b>")&"</a>","//a"),LEN(A2)-11)

博爱风雨同舟 · 发表于 2024-5-6 19:18

=TEXTJOIN("*",,BYCOL(--MID(0&$A2,SMALL(IF(MMULT(1-ISERR(-(MID("〇"&$A2,ROW($1:$66)+{0,1},1))),{10;1})=1,ROW($1:$66)+1),COLUMN(A:C)),SEQUENCE(9)),LAMBDA(X,LOOKUP(9E+307,X))))

我的城市你来过 · 发表于 2024-5-6 19:22

=TEXTBEFORE(SUBSTITUTE(SUBSTITUTE(A2,"（T)",""),"（L)",""),"(")

mykitami · 发表于 2024-5-6 21:28

=CONCAT(TEXTSPLIT(A2,TEXTSPLIT(A2,VSTACK(SEQUENCE(10)-1,"*","."),,1),,1))

boyuanoffice · 发表于 2024-5-6 21:57

本帖最后由 boyuanoffice 于 2024-5-6 21:59 编辑

=REGEXP(A2,"[^.*\d]+",2)

=CONCAT(REGEXP(A2,"[.*\d]+"))

阿龙老师 · 发表于 2024-5-6 22:10

本帖最后由阿龙老师于 2024-5-6 22:15 编辑

=TEXTJOIN("*",1,TAKE(TEXTSPLIT(A2,"（","*"),,1))

roserice · 发表于 2024-5-7 20:01

用PQ = Table.AddColumn(x, "自定义", each Text.Remove([数据源],{"（","）","(",")","A".."z"}))

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

[已解决] 多个数字提取