函数提取小时前的数字

钓鱼岛特区

感谢........

华大喷

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

潇门小雨

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

刘少军

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

罗明超

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

路人甲干上路人乙

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

靖博

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

田野里的九九

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

废话不多说

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

李小爷

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