Quote:
Originally Posted by projectpupil7
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.
|
Try this UDF:
Public Function SS(S As String) As String
SS = Trim(Split(S, "/")(3))
End Function
Bruno