title: Replace text in a function in Google Sheet (with script)
body: <p>I'm trying to replace strings in a sheet. It works just fine for all my text values, but I have a problem with functions. </p>
  
  <p>I have phone numbers that are imported but unfortunately, I get a <code>=+</code> placed in front of them.</p>
  
  <p>So the values are not 555-8181, its =+555-8181.</p>
  
  <p>When I try to use for example Replace it doesn't work, likely because the values are stored as a function, and not a string, but I can be wrong.</p>
  
  <p>Any hints on what to do?</p>
  
  <p>Example of what I have tried:</p>
  
  <pre><code>function RemoveErrorInPhonenumber() {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("SheetWithNumbers");
    var range = sheet.getRange("Z:AG");
    var rngA = range.getValues();
    for(var i=1;i&lt;rngA.length;i++)
    {
      rngA[i][0]=rngA[i][0].toString().replace("+", "");
  
    }
    range.setValues(rngA);
  };
  </code></pre>