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