excel

反向查找,截取字符串

=IFERROR(MID(M7,FIND("+",SUBSTITUTE(M7,"\","+",LEN(M7)-LEN(SUBSTITUTE(M7,"\",""))))+1,FIND(".js",M7)-FIND("+",SUBSTITUTE(M7,"\","+",LEN(M7)-LEN(SUBSTITUTE(M7,"\",""))))-1),"")

 

posted @ 2022-05-26 08:34  小摔哥#1  阅读(21)  评论(0编辑  收藏  举报