Find the last occurrence of character in a cell in Excel

Formula
This is for a \ in cell A2, as in a file path
 * =MID(A1,FIND("*",SUBSTITUTE(A1,"\","*",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))+1,LEN(A1))