LEFT
function LEFT(arg1: string = null, arg2: number = null): stringDescription
Returns the specified number of characters from the start of a text string.
Parameters
- arg1
stringdefault: null The text string containing the characters to extract.
- arg2
numberdefault: null A number of the substring characters. It must be greater than or equal to 0.
Returns
stringTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.LEFT("Online Office", 6));