起跑线 发表于 2021-12-22 13:39:21

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

剑威堡男装 发表于 2021-12-24 22:06:18

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

科兰 发表于 2021-12-28 01:51:06

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

无聊看看 发表于 2021-12-28 19:14:53

ctrl+e

只为幸福 发表于 2022-1-1 05:56:25

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

名字不赖 发表于 2022-1-3 07:56:45

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

两千金 发表于 2022-1-6 08:33:48

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

鹰的眼睛 发表于 2022-1-8 20:27:03

你是想卡死楼主吗

星光客 发表于 2022-1-12 11:15:39

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

绿穗子 发表于 2022-1-13 10:07:53

干脆来狠的吧
=IFNA(MATCH(,-FIND(" "&ROW(A:A)%&"小",A2))%,"")
页: 1 2 [3] 4
查看完整版本: 函数提取小时前的数字