Hi all, my first question as a newbie.

I have hundreds of text entries in a worksheet typically like this

"Landlord work 110 / RJ*** / 2002 / RJL513 / 0 / A**** / AMSHDAM"

and what i need to do is extract this "RJL513" piece of text from the string.



I have tried using this =MID(R3,FIND("/",R3)+1,6) but can only get to the first slash.