Question

excel提取2个关键字符中间的数字？

如：
ata\500\600\119607_sss\333\555
ta\0\2022\620\500\600\119608_1\666
a\500\600\Data\0\2022\620\500\600\1222107_a.jpg
想提取列表中最后一个"\"和"_"之间的数字

Answer 1

=MID(A1,FIND("#",SUBSTITUTE(A1,"\","#",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))+1,FIND("_",A1)-FIND("#",SUBSTITUTE(A1,"\","#",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))-1)

Answer 2

见样表截图

B2输入  

=LOOKUP(9^9,--LEFT(MID(A2,-LOOKUP(,-FIND("\",A2,ROW(A:A)))+1,99),ROW($1:$99)))

公式下拉