|This formula should get you going on half your problem:|
The text string should be in cell A1
The word your looking for in cell D1
In Cell B1 enter the formula:
Modify to suit your needs.