按照下面的步骤: =LEN(A1)-LEN(SUBSTITUTE(A1,"\","") 判断"\"个数=FIND("★",SUBSTITUTE(A1,"\","★",(LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))) 判断最后一个"\"的位置。★可改成最A1单元格中最不可能出现的字符 然后用mid函数就可以取得文件名