Text in string

Bruno Campanini · #7 11-22-2014, 08:07 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Way to search for a string in text file, pull out everything until another string?	omahadivision	Excel Programming	12	11-23-2013 12:10 PM
Extracting a phone number from a string that contains text and numbers.	hommi16	Excel	2	06-05-2013 09:19 PM
Find and replace a string of text	errtu	Word	1	01-31-2013 02:09 PM
Convert numbers to a specific text string	francis	Excel	1	10-06-2011 01:43 PM
Extract numbers from a text string	aleale97	Excel	4	02-10-2011 10:33 AM