I have an excel file containing keywords and what i want to have printed if that keyword is found in a string. A row looks something like this:
The first cell i have no trouble with, it works fine to search a string if Something is in it. The second cell I want to print Something with another word attached to it (SomethingSomewhere).
I've tried this using matrices instead of excel and it works perfectly. The issue with that is that its difficult to update keywords and the printed phrases, which I will need to too often for that to work.
My problem is excel saves the cells as '"Something"+c' (Including the single quotes) which defeats the purpose of the c variable. I cannot find any way to remove those single quotes around it. I wanted it saved as just "Something"+c and have the same result this would:
So that its output is SomethingSomewhere insead of "Something"+c.
My actual code is
if contains(lstr,s(i)) == 1
I found a few related posts, but none of the suggestions would work. For example I tried: