函数提取小时前的数字

起跑线

=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),"")

无聊看看

ctrl+e

只为幸福

=IFNA(MATCH(,-FIND(" "&ROW($1:240)/10&"小",A2))/10,"")

名字不赖

干脆来狠的吧
=IFNA(MATCH(,-FIND(" "&ROW(A:A)%&"小",A2))%,"")

两千金

=IFERROR(-LOOKUP(1,-LEFT(MID(A2,--MAX(IFERROR(FIND(" ",A2,ROW($1:$99)),"")),99),ROW($1:$99))),"") 三键结束

鹰的眼睛

你是想卡死楼主吗

星光客

=IFNA(MATCH(,-FIND(" "&ROW($1:240)/10&"小",A2))/10,"")

绿穗子

干脆来狠的吧
=IFNA(MATCH(,-FIND(" "&ROW(A:A)%&"小",A2))%,"")