TRIM
function TRIM(arg1: string = null): stringDescription
Removes all spaces from a text string except for single spaces between words.
Parameters
- arg1
stringdefault: null The text from which the spaces will be removed.
Returns
stringTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.TRIM(" Online Office"));