Looking for certain words in a string

		Microsoft Office Forums > Microsoft Excel > Excel
Looking for certain words in a string

FAQ

Thread Tools

Display Modes

08-07-2019, 02:03 AM

xor

Windows 10 Looking for certain words in a string

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

Looking for certain words in a string

With your text string in A1 use

=IFERROR(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),MAX(1,FIND("marble",SUBSTITUTE(A1," ",REPT(" ",99)))-50),99)),"")

to extract marble.

In another cell to extract glass

=IFERROR(TRIM(MID(SUBSTITUTE(A1;" ";REPT(" ";99));MAX(1;FIND("glass";SUBSTITUTE(A1;" ";REPT(" ";99)))-50);99)),"")

and so on.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to find (highlight) two and more words in a list of 75k single words in Word 2010	Usora	Word	8	05-29-2018 03:34 AM
Wildcard replace any string in context with a specified string	wardw	Word	7	05-07-2018 09:13 AM
How can I compare a string in a cell to another string?	Amitti	Word VBA	2	04-10-2017 07:35 PM
How to find all string within string.	PRA007	Word VBA	18	02-12-2016 08:11 PM
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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:42 AM.