How to get string after 3 slash in excel

Question

I'm having difficulties to find a way of getting the string before the last slash in excel 2007 formula.

https://www.example.com/text13611283/url_complement

The string I need is this: text13611283

Answer 1

There are multiple ways to do this task based on input value Case 1: you can Delimit the column by using menu "DATA/Text to Columns"

Case 2: Assuming your text is in A2 Cell the formula in B2 will be "=LEFT(MID(A2,FIND("/",A2,10)+1,100),FIND("/",MID(A2,FIND("/",A2,10)+1,100),1)-1)"