Excel Formula to extract the Path from a filename

If you have C:\Temp\Files\1.txt

this wil lreturn C:\Temp\Files\

=MID(F1,FIND("*",SUBSTITUTE(F1,"\","*",LEN(F1)-LEN(SUBSTITUTE(F1,"\",""))))+1,LEN(F1))