Excel Get text between two characters

Question

I'm trying to get the text between the last / and ' in the column below:

So that my answer will be:

I tried using the formulas:

=MID(A5, SEARCH("/", A5)+1, SEARCH("''", A5) - SEARCH("/", A5) -1)

and

=MID(RIGHT(A5,FIND("/",A5)-1),FIND("/",A5)+1,LEN(A5))

But unfortunately, they aren't working. 

Answer 1

Try this:

=SUBSTITUTE(TEXTAFTER(A1:A4,"/",-1),"'","")

Here is the output: 

Similarly to get the text before:

=SUBSTITUTE(TEXTBEFORE(A1:A4,"/",-1),"'","")