next up previous contents index
Next: FLOOR, XLFLOOR Up: A. Function Reference Previous: FILEEXISTS   Contents   Index


FIND

Syntax: FIND(S1, S2, N)

S1 = a string value
S2 = a string value
N = a numeric value

FIND returns the index of the first occurrence of string S1 in string S2, starting the search at position N in string S2. Note that the string index always starts with 0.

Examples:

FIND(``bc'', ``abcdefg'', 0) = 1

FIND(V1, V2, 5) = 9, where V1 = ``Functions'', and V2 = ``Built-in Functions''

FIND(V1, V2, 5) = Error - FIND, substring not found, where V1 = ``Built-in'' and V2 = ``Functions''

Excel function: N/A


next up previous contents index
Next: FLOOR, XLFLOOR Up: A. Function Reference Previous: FILEEXISTS   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003