It is challenging sometimes to find last occurrence of a character in a string. I hope the following formula can help:
=SEARCH("@",SUBSTITUTE(A1,"\","@",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))
* Considering that the Text is in cell A1, and we are looking for "\" character.