Removing text after last \

[frostie77]

Hi

I have a load of file paths that need to be amended by removing the file name at the end.
For example

aaaaz\bbbbbb\aaaaa\aaaa\aaaa\iiii

and to show as below

aaaaz\bbbbbb\aaaaa\aaaa\aaaa\

All of the file paths are different. Is their a formula or a bit of code I can use to remove everything after the last \

Thanks

[DonkeyOte]

Quite a few options here - assume original in A1 then:

B1:
=LEFT(A1,FIND("^^",SUBSTITUTE(A1,"\","^^",LEN(A1)-LEN(SUBSTITUTE(A1,"\","")))))

[frostie77]

Thank you that worked perfectly