Text in string

		Microsoft Office Forums > Microsoft Excel > Excel
Text in string

FAQ

Thread Tools

Display Modes

11-21-2014, 10:11 PM

jolivanes

Windows XP Text in string

Office 2007

Advanced Beginner

Join Date: Sep 2011

Posts: 91

jolivanes will become famous soon enough

If it is always between the 3rd and 4th forward slashes, this does it also I think.
=TRIM(MID(A3,FIND(CHAR(1),SUBSTITUTE(A3,"/",CHAR(1),3))+1,FIND(CHAR(1),SUBSTITUTE(A3,"/",CHAR(1),4))-1-FIND(CHAR(1),SUBSTITUTE(A3,"/",CHAR(1),3))))

« 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:19 PM.