Search for specific data in a text string

		Microsoft Office Forums > Microsoft Excel > Excel
Search for specific data in a text string

05-20-2017, 11:51 AM

xor

Windows 10 Search for specific data in a text string

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

With your text in A1 try:

--MID(A1,FIND("AGE",A1)+5,FIND(" ",A1,FIND("AGE",A1)+5)-(FIND("AGE",A1)+5))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Table – Search All Tables - Find & Replace Text in Table Cell With Specific Background Color	jc491	Word VBA	8	09-30-2015 06:10 AM
Search for multiple texts in cell, return specific text	mariur89	Excel	4	12-14-2014 01:33 AM
Search first section for specific string...	donaldadams1951	Word VBA	4	03-14-2014 11:24 AM
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
Convert numbers to a specific text string	francis	Excel	1	10-06-2011 01:43 PM

Other Forums: Access Forums

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