Forum Discussion
Find word from list (string) - without macros
Hi everbody, I am trying to find specific words from a list of items. I want to know if the word is in the strings given, and if it is, bring to cell C the classification of each item. I want ...
Hi HansVogelaar
May I ask what does the "1000" do in that case?
Sometimes is working, sometimes is not...
Plus, I need something with a higher limit, does something else come to your mind?
Thanks!
1000 is an arbitrary large number. You can change it to 1000000 or 1000000000 if 1000 is not large enough.