vba - Extracting text string after nth occurrence of a character in Excel (functions or VB) -

vba - Extracting text string after nth occurrence of a character in Excel (functions or VB) -

looking vb or excel function return

azat-tab-25mg

from

y:\master-documentation\azat\dp\tab\25mg\2-drug-product\azat-tab-25mg-dp-1-bmi-[d-6475703-01-11].pdf

is there function text after 7th occurrence of \?

if have info in cell a1 next worksheet formula extracts after 7th "\"

=replace(a1,1,find("^^",substitute(a1,"\","^^",7)),"")

substitute function replaces 7th "\" "^^" [use character or combination of characters know won't appear in data]

...then find function finds position of "^^" , allows replace function replace characters , before nothing.

excel vba excel-vba