永无休止 发表于 2021-10-8 15:20:00

函数提取小时前的数字

图片中效果


伍十三 发表于 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

你是想卡死楼主吗
页: [1] 2 3 4
查看完整版本: 函数提取小时前的数字