Looking for certain words in a string

Guinness · #1 08-06-2019, 07:07 PM

I have almost 1000 records (strings) that I need to pull a whole list of words out of. I know I can't do it with nested formulas. What would be the best way to do that?

xor · #2 08-07-2019, 02:03 AM

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.

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

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