已知A1=http://www.163.com/sports/Arsenal.html,要获取Arsenal.html字符串。
=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",LEN(A1))),LEN(A1)))
字符串第2次出现的位置
=FIND("-",A1,FIND("-",A1)+1)
字符串第n次出现的位置(这种方法比较好)
=FIND("!",SUBSTITUTE(A1,"-","!",n))
A2中的内容:12-13-4-301
截取楼号 单元 室
楼号
=LEFT(A2,FIND("-",A2,FIND("-",A2)+1)-1)
单元
=MID(A2,FIND("!",SUBSTITUTE(A2,"-","!",2))+1,FIND("!",SUBSTITUTE(A2,"-","!",3))-1-FIND("!",SUBSTITUTE(A2,"-","!",2)))
室
=RIGHT(A2,LEN(A2)-FIND("!",SUBSTITUTE(A2,"-","!",3)))