FIND
function FIND(arg1: string = null, arg2: string = null, arg3: number = null): numberDescription
Returns the starting position of one text string within another text string. This function is case-sensitive.
Parameters
- arg1
stringdefault: null The text to find. Use double quotes (empty text) to match the first character in the search string. Wildcard characters are not allowed.
- arg2
stringdefault: null The text containing the text to find.
- arg3
numberdefault: null Specifies the character at which to start the search. The first character in the search string is character number 1. If omitted, this parameter is equal to 1.
Returns
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.FIND("line", "Online Office"));