MID

Returns the characters from the middle of a text string, given a starting position and length.

Syntax

expression.MID(arg1, arg2, arg3);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

Name	Required/Optional	Data type	Default	Description
arg1	Required	ApiRange | ApiName | string		The text string from which to extract the characters.
arg2	Required	ApiRange | ApiName | number		The position of the first character to extract. The first text character is 1.
arg3	Required	ApiRange | ApiName | number		A number of the characters to extract.

Returns

string

Example

• Code
• Result

let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
worksheet.GetRange("A1").SetValue(func.MID("Online Office", 3, 4));