title: replace \u0087 with "" using VBA
body: <p>I have data in an Excel sheet that has been downloaded by a Power Query and there are <code>\u0087</code> characters</p>
  <p><a href="https://i.stack.imgur.com/JSvRG.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JSvRG.jpg" alt="enter image description here" /></a></p>
  <p>I am trying to replace the character <code>\u0087</code> with <code>&quot;&quot;</code> with VBA:</p>
  <pre><code>.Replace &quot;‡&quot;, &quot;&quot;
  .Replace &quot;u0087&quot;, &quot;&quot;
  .Replace what:=Chr(135), replacement:=&quot;&quot;
  </code></pre>
  <p>But it is not replacing even though this method work fine for other characters like Em-Dash</p>
  <pre><code>.Replace what:=&quot;–&quot;, replacement:=&quot;-&quot;
  .Replace what:=Chr(150), replacement:=Chr(45)
  </code></pre>
  <p>Why this is not working? How to make it work</p>