Hi
I am trying to extract text from a cell, everything left of the second backslash (eg. Refining\Breakdown\ChipSupply\ChipSilo\Screw will become Refining\Breakdown)
I have tried using =LEFT(B33,FIND("\",B33)) but this only gets me past the first backslash
How do I get to the next one in the string?
Cheers
David
Bookmarks