title: How to decode specific characters (unicode) in Google Sheets
body: <p>I have a Sheets that contains text as <code>dÃ©fi</code> (défi) or <code>Ã–sterreich</code> (Östereeich).</p>
  <p>I can decode the first by this script, on the other hand I am not able to do the second (I mean the code takes 3 bytes)</p>
  <p>Thanks for any help!</p>
  <pre><code>function decode(txt){
    var texte = []
    for (i=0;i&lt;txt.length;i++){
      var n = txt.substring(i,i+1).charCodeAt()
      if (n&gt;127){
        if ((n &amp; 32) &gt; 0){
          //texte.push(decode_utf8(txt.substring(i,i+3))) ??
          i+=2
        }
        else{
          texte.push(decode_utf8(txt.substring(i,i+2)))
          i++
        }
      }
      else{
        texte.push(txt.substring(i,i+1))
      }
    }
    return (texte.join(''))
  }
  function decode_utf8(s) {
    return decodeURIComponent(escape(s));
  }
  </code></pre>