Function INDEX() could tell u the location of the first target word it finds in the source string.
Now, your source string is "BLACKSMITH WORDSMITH SWORDSMITH", and your target word is "SMITH". So, we'll see
123456789012345678901234567890123
BLACKSMITH WORDSMITH SWORDSMITH
SMITH