formula split path

[max_max]

Hi to all,
formula spit:

C:\Users\massimo\etichette\P01235666688
or
C:\Users\massimo\Desktop\ciao\ciao\ciao\ciao\etichette\jfjfjfjfj
or
C:\Users\massimo\Desktop\etichette\rty8744_RUTP

only rigt last \

max

[tim201110]

=mid(a1,aggregate(14,6,row(indirect("1:"&len(a1)))/(mid(a1,row(indirect("1:"&len(a1))),1)="\"),1)+1,100)

[FDibbins]

Another way...
=MID(A2,SEARCH("@",SUBSTITUTE(A2,"\","@",LEN(A2)-LEN(SUBSTITUTE(A2,"\",""))))+1,99)