Search/extract text

Originally Posted by Special-K

Assuming there are always four seperators of "\" in the string and the character you are looking for is just before the fourth "\" try this

=MID(A1,SEARCH(CHAR(127),SUBSTITUTE(A1,"\",CHAR(127),4))-1,1)

That worked great.. Thanks you!!!