title: Find and extract the next word after the search term using Excel formula
body: <p>I am looking through text strings of variable length to see what chemicals were applied. The chemical name is usually given after the word "apply" or "spray". Therefore I want to extract the next word after the term "spray" or "apply" has been used. The search strings are of variable length and the search terms are not in the same place.</p>