Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 8504.40.9031 9403.70.0000
- 8504.40.9090 9403.70.8031
- 8504.40.9510 9403.70.9000
- 8504409031 9403700000
- 8504409090 9403708031
- 8504409510 9403709000
- function appendString() {
- var range = SpreadsheetApp.getActiveSheet().getActiveRange();
- var numRows = range.getNumRows();
- var numCols = range.getNumColumns();
- var writeValues = []
- for (var i = 1; i <= numRows; i++) {
- var row = []
- for (var j = 1; j <= numCols; j++) {
- var currentValue = range.getCell(i,j).getValue();
- var withString = currentValue.toString().replace(".","");
- row.push(withString)
- }
- writeValues.push(row)
- }
- range.setValues(writeValues)
- }
- 850440.9031 940370
- 850440.909 940370.8031
- 850440.951 940370.9
Add Comment
Please, Sign In to add comment