I'm looking for a suggestion or code on finding text within a string.

For example, I have a field in an Excel spreadsheet that contains a
description of a user issue.

I want to categorize these descriptions by finding a specific word in the
description, e.g., claim, lawsuit, refund, etc. These specific words are
supposed to appear at the beginning of the description but users may place
them anywhere in the description.

I thought of doing using the 'mid' and cycling through the description but
that doesn't seem to be a very efficient way to validate whether a specific
word appears in the description.

Thanks for the help...


--
JT