divide text string with a formula

Hello you can divide text string with a formula?

in B2 C:\Users\utente\Desktop\fogli_viterie\

in B1 C:\Users\utente\Desktop\
in D1 \fogli_viterie\
-------------------------------------------------
in B2 C:\Users\utente\Desktop\foglio materiali\

in B1 C:\Users\utente\Desktop\
in D1 \foglio materiali\
-------------------------------------------------
in B2 C:\Users\utente\Desktop\COMMESSE\PIPPO-12345\

in B1 C:\Users\utente\Desktop\COMMESSE\
in D1 \PIPPO-12345\
-------------------------------------------------

thanks in advance.
max_max

B1: =REPLACE(B2,1,LEN(D1)-1,"")
D1: =LEFT(B2,FIND("^",SUBSTITUTE(B2,"\","^",LEN(B2)-LEN(SUBSTITUTE(B2,"\",""))-1)))


Note, B1 will not funciton on it's own, it depends on the result of D1.

Hello jonmo1
B1 is accurate
D1 = 0 ???

That makes no sense, as I wrote them, B1 is dependant on a result from D1.
So how can B1 be accurate, but D1 is 0 ??

Anyway, they work for me.
Example

Hello jonmo1,
It is accurate it was my mistake.
Thank you.
max_max

You're welcome.