Thread: [Solved] Find first mention of word from list.
View Single Post
 
Old 12-15-2020, 10:08 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
I assume clearwords is a custom function someone wrote?

Well below is a formula with a named table, looks like it does what you are after

=MID(A2,AGGREGATE(15,6,SEARCH(Words,A2),1),SEARCH( " ",A2,AGGREGATE(15,6,SEARCH(Words,A2),1))-AGGREGATE(15,6,SEARCH(Words,A2),1))
Attached Files
File Type: xlsm Copy of Book2_Purlfeet.xlsm (12.8 KB, 9 views)
Reply With Quote