CONCATENATE
function CONCATENATE(arg_n: string = null): stringDescription
Combines multiple text strings into one text string.
Parameters
- arg_n
stringdefault: null Up to 255 data values that will be combined.
Returns
stringTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.CONCATENATE("John", " ", "Adams"));