求大神指导，一组带符号数据只提取其中的数字数值

zuiai331

因数据不在一个表格内想每组数据单独提取，请大神指导非常感谢

xlllw203

1. =TEXT({1,-1,0}%,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A2,"/",";"),"s",),"min",))

复制代码

低版本的话，需选B2:D2单元格，三键输入数组公式

miaojohn45

1. =TEXTSPLIT(A2,{"/","s","min"},,1)

复制代码

我走我流

BCD的区域数组 =--SUBSTITUTE(SUBSTITUTE(TRIM(MID(SUBSTITUTE(LOWER(A2),"/",REPT(" ",99)),{1,2,3}*99-98,99)),"s",),"min",)

无关岁月

365

1. =DROP(REDUCE("",A2:A14,LAMBDA(_a,_b,VSTACK(_a,MAP(TEXTSPLIT(_b,"/"),LAMBDA(_c,-LOOKUP(,-LEFT(_c,ROW(1:9)))))))),1)

复制代码

zuiai331

miaojohn45 发表于 2024-3-14 10:44

非常非常感谢！辛苦了

博爱风雨同舟

=TEXT({1,-1,0},TEXTJOIN(,1,TEXTSPLIT(SUBSTITUTE(A2,"/",";"),CHAR(ROW($97:$122)))))

cnmlgb9998

PQ !!!!!!!!!!!!!!!!!!!!!!!!!!

ifan0916

1. =TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A3,"s",),"min",),"/",REPT(" ",99)),COLUMN(A1)*99-98,99))

复制代码

solextrade

=-LOOKUP(,-LEFT(MID($A2,FIND("@",SUBSTITUTE("/"&$A2,"/","@",COLUMN(A1))),9),ROW($1:$9)))