Extract filename from a URL stored in cell C1
=MID(C1,FIND("|",SUBSTITUTE(C1,"/","|",LEN(C1)-LEN(SUBSTITUTE(C1,"/",""))))+1,LEN(C1))
Extract filename from a URL stored in cell C1
=MID(C1,FIND("|",SUBSTITUTE(C1,"/","|",LEN(C1)-LEN(SUBSTITUTE(C1,"/",""))))+1,LEN(C1))