title: Google Apps Script Replace and update cell within a range
body: <p>I have a Google spreadsheet that I'm trying to remove the word "woo" within a range of cells
  So far I've managed to loop through the results and log the results, however I haven't figured how to update that information in the spreadsheet itself.</p>
  
  <p>Any guidance would be welcomed</p>
  
  <p>Thank you</p>
  
  <pre><code>function myFunction () {
    var ss = SpreadsheetApp.getActiveSheet().getRange('B:B')
    var data = ss.getValues();
    for (var i = 0; i &lt; data.length; i++) {
      var text = data[i].toString();
      var finaltext = text.replace(/woo/g, "");
      data[i] = finaltext;
      Logger.log(data[i]); 
    }
  }
  </code></pre>