I have a text string in Excel which contains 4 "/". I need the text (including "/'s" that come BEFORE the final "/"
The text can be of varied length, and is for instance
/Purchasing/Cambridge/d-division/jB8k4xLu
I want to only extract
/Purchasing/Cambridge/d-division
Bookmarks