Google Sheets Split Text to Columns: Using Google Apps Script

[@craig-alicious]

Cheers for that. So clear.

[@varunp9007]

Request you to share the code

[@testaccount6075]

I used other var names though, but this should work. function splitColumn() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var commaSheet = ss.getSheetByName('Sheet15'); var dotSheet = ss.getSheetByName('Sheet14'); var lastRowComma = commaSheet.getLastRow(); var commaRange = commaSheet.getRange('A1:A' + lastRowComma); commaRange.splitTextToColumns(','); var lastRowDot = dotSheet.getLastRow(); var dotRange = dotSheet.getRange('A1:A' + lastRowDot); dotRange.splitTextToColumns(':'); } // function

[@alexandersafonov2795]

gj