I'd like to split text in every row to columns and remove the $ character from the text using Google Apps Script in a Google Sheet.I found a split text to column script (below). It only splits the text in the first row to columns. How to modify the below script to split texts in all row to columns meanwhile remove the $ in every row? I am not a developer, so it would be appreciated if someone could help me here.function mySplit() {  var sh = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();  var cell = sh.getActiveCell().getValues()[0];  var sCell = cell[0].split( );  var row = sh.getActiveCell().getRowIndex();  var col = sh.getActiveCell().getColumnIndex();  sh.getRange(row,col+1,1,sCell.length).setValues([sCell]);}  
How to loop Split text to columns and remove a character in every iteration using Google Script?
google spreadsheets;google apps script