Text in string

		Microsoft Office Forums > Microsoft Excel > Excel
Text in string

FAQ

Thread Tools

Display Modes

11-05-2014, 01:39 AM

projectpupil7 projectpupil7 is offline

Windows 7 64bit Text in string

Office 2010 64bit

Novice

Join Date: Nov 2014

Posts: 5

projectpupil7 is on a distinguished road

Text in string

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:05 PM.