Hi everyone,
I am trying to make a following flow.
I would be grateful if you could give me some advice.
-FLOW-
1. Delete all the space
2. Separate text by semicolon into each cell
↓This is the result I would like to get
Hey,
The only way to automatically structure data like that would be with a "run script" (in Excel) action.
function main(workbook: ExcelScript.Workbook) {
// Variables
let selectedSheet = workbook.getActiveWorksheet();
let columnA = selectedSheet.getRange("A:A");
let lastrow = columnA.getUsedRange().getRowCount();
let range = "A1:A" + lastrow
// Replace all " " with "" on column A on selectedSheet
columnA.replaceAll(" ", "", {completeMatch: false, matchCase: false});
// Text to columns on column A on selectedSheet
for (let row = 0; row < selectedSheet.getRange(range).getRowCount() ; row++) {
let sourceRange = selectedSheet.getRange(range);
let destinationRange = selectedSheet.getRange("A1");
let sourceRangeValues = sourceRange.getRow(row).getValues()[0][0].toString().split(/[;]/)
destinationRange.getOffsetRange(row, 0).getResizedRange(0, sourceRangeValues.length - 1).setValues([sourceRangeValues]);
}
}
Michael E. Gernaey
18
Super User 2025 Season 1
stampcoin
14
Churchy
12