I have a single cell that can contain up to 41 different text strings that are like this:
text/text/Above 1/text where I can have Above 1, Below 1 or Below Ground
I'm looking for a function that will tell me if that text sting contains a certain word (like "Above 1" in the example above). I want to use the result of that function as an argument for an IF function. I've already used a combination LEFT/SEARCH function, but since the text length before and after what I'm looking for (e.g. Above 1) varies, it isn't working.
Any ideas?
TIA
Bookmarks