函数提取小时前的数字

永无休止 · 2021-10-8 15:20:00

图片中效果

文件1.rar (6.79 KB, 下载次数: 175)

伍十三 · 2021-10-13 14:31:55

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

呢称东土炎黄龙国 · 2021-10-14 03:44:25

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

吉林杰哥 · 2021-10-15 15:58:53

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

红山 · 2021-10-24 22:21:16

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

巴川悍匪 · 2021-10-27 08:44:38

ctrl+e

蜡笔小新很纯洁 · 2021-11-2 22:34:40

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

南方化妆品 · 2021-11-5 03:41:51

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

重拾信心 · 2021-11-7 04:07:04

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

我本凡人 · 2021-11-8 05:01:10

你是想卡死楼主吗

		自动登录	找回密码
密码			立即注册