Text in string

		Microsoft Office Forums > Microsoft Excel > Excel
Text in string

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 12:18 PM.