SCAN
Returns a number which indicates the starting location of the first occurrence of a
string within another string.
Syntax
SCAN(String1, String2)
String1 is the string to search for.
String2 is the string in which the search occurs. Both
arguments must be strings or formulas that return strings. If String1 does not occur in String2, then the
function returns 0.
Example
This example returns 6:
SCAN('IACTA', 'Alea IACTA EST')