INSTRING function

[Iain Wicks]

Is there a function like "INSTRING" or something similar
which will help me search for word within a field.
e.g. I want to look for the word Hopital within a field.

Thanks

iain

 

[Frank Kabel]

Hi
1. Worksheet functions:
SEARCH
FIND

2. VBA:
InStr