钓鱼岛特区 发表于 2021-11-10 10:48:41

感谢........

华大喷 发表于 2021-11-12 01:34:33

MID(SUBSTITUTE(A2," ",REPT(" ",9)),FIND("小时",A2&"小时")+16,8)

潇门小雨 发表于 2021-11-15 10:29:38

=SUBSTITUTE(MID(A2,COUNT(FIND(" ",A2,ROW($1:$99)))+1,99),"小时","")

刘少军 发表于 2021-11-19 01:13:35


=SUBSTITUTE(VLOOKUP(" *小时",MID(A2& " 小时",ROW($1:$99),9),1,),"小时",)

罗明超 发表于 2021-11-21 17:52:12

你做的是风险题。。。
=-LOOKUP(,-MID(A2&0,FIND("小",A2&"0小")-{1,2,3},{1,2,3}))

路人甲干上路人乙 发表于 2021-12-1 07:40:35

=IFERROR(-LOOKUP(1,-MID(A2,FIND("小时",A2)-ROW($1:$9),ROW($1:$9))),"")

靖博 发表于 2021-12-12 09:11:58

=IFERROR(--SUBSTITUTE(RIGHT(SUBSTITUTE(A2," ",""),5),"小时",),"")

田野里的九九 发表于 2021-12-14 20:15:39

=IFERROR(SUBSTITUTE(MID(A2,LOOKUP(9^9,FIND(" ",A2,ROW(1:99)))+1,99),"小时",),"")

废话不多说 发表于 2021-12-15 22:06:53

=IFERROR(MID(A2,FIND("@",SUBSTITUTE(A2," ","@",3))+1,LEN(A2)-FIND("@",SUBSTITUTE(A2," ","@",3))-2),"")

李小爷 发表于 2021-12-19 14:49:02

=IFERROR(-LOOKUP(1,-MID(A2,FIND("小时",A2)-ROW($1:$9),ROW($1:$9))),"")
页: 1 [2] 3 4
查看完整版本: 函数提取小时前的数字