Removes all spaces from a text string except for single spaces between words.
Name | Type | Description |
arg1 | string | The text from which the spaces will be removed. |
builder.CreateFile("xlsx"); var oWorksheet = Api.GetActiveSheet(); var oFunction = Api.GetWorksheetFunction(); oWorksheet.GetRange("A1").SetValue(oFunction.TRIM(" Online Office")); builder.SaveFile("xlsx", "TRIM.xlsx"); builder.CloseFile();