Add to extract just the folder name

=MID(A1,LARGE((MID(A1,ROW(1:255),1)="\")*IFERROR(SEARCH("\",A1,ROW(1:255)),0),2)+1,LARGE((MID(A1,ROW(1:255),1)="\")*IFERROR(SEARCH("\",A1,ROW(1:255)),0),1)-LARGE((MID(A1,ROW(1:255),1)="\")*IFERROR(SEARCH("\",A1,ROW(1:255)),0),2)-1) and this will give

Misc Pics

=MID(A1,LARGE((MID(A1,ROW(1:255),1)="\")*IFERROR(SEARCH("\",A1,ROW(1:255)),0),3)+1,LARGE((MID(A1,ROW(1:255),1)="\")*IFERROR(SEARCH("\",A1,ROW(1:255)),0),2)-LARGE((MID(A1,ROW(1:255),1)="\")*IFERROR(SEARCH("\",A1,ROW(1:255)),0),3)-1)

World Over