Concatenate 2 columns using excel formula

PHOTO EMBED

Mon May 23 2022 04:24:57 GMT+0000 (Coordinated Universal Time)

Saved by @bobgorbold

let sheet = workbook.getActiveWorksheet();
	// Insert at range G:G on selectedSheet, move existing cells right
let range = selectedSheet.getUsedRange();
let rowCount = range.getRowCount();
	// Set range G2 on selectedSheet
sheet.getRange("G2").setFormulaLocal("=CONCAT(H2,\" \", I2)");
	// Auto fill range
sheet.getRange("G2").autoFill("G2:G"+rowCount, ExcelScript.AutoFillType.fillDefault);
	sheet.getRange("G2").copyFrom(sheet.getRange("G2:G1048576"), ExcelScript.RangeCopyType.values, false, false);
	sheet.getRange("G:G").getFormat().autofitColumns();
content_copyCOPY