Forum

Notifications
Clear all

Search string for word from a list

2 Posts
1 Users
0 Reactions
161 Views
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
Topic starter
 

Hi.  I still haven't figured this out.  Maybe a better explanation is needed.  I need a formula to look into a long string (500+/- char) for a word that appears in a list.  For example:

FindWordinaString.JPG

 
Posted : 08/08/2019 6:59 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
Topic starter
 

Hi Roxanne,

Please start a new topic when you have anew qs, rather than add to an existing topic on a different subject.  I've moved this post here.

Not sure what you mean by 'a better explanation is needed'- we haven't given you any reply yet as this is the first time you've posted this qs?

This article describes the solution you need

https://www.myonlinetraininghub.com/excel-search-string-for-a-list-of-words

Phil

 
Posted : 08/08/2019 9:07 pm
Share: