title: converting unicode emotion characters while parsing from api result (excel macro)
body: <p>After I have parsed API results in Excel, I have trouble with unicode characters. There are lots of emoticons like smilies and hearts etc.</p>
  
  <p>They appear like <code>\ud83d\ude09\ud83d\ude09\ud83d\ude09\ud83d\ude09</code>, but I want them to display like this: </p>
  
  <p>'this is my code</p>
  
  <pre><code>Set objHTTP = CreateObject("WinHttp.WinHttpRequest.5.1")
  objHTTP.Open "Get", URL, False
  objHTTP.SetRequestHeader "User-Agent", "Mozilla/4.0 (compatible; MSIE   6.0; Windows NT 5.0)"
  
  objHTTP.SetRequestHeader "Content-Type", "application/x-www-form-urlencoded"
  
  objHTTP.send
  
  
  ''objHTTP.Response.contentType = "text/xml"
  
  
  strResult = objHTTP.ResponseText
  
  strResult = Replace(strResult, "\u0026", "&amp;", 1)
  
  strResult = Replace(strResult, "\u011f", "ğ", 1)
  strResult = Replace(strResult, "\u011e", "Ğ", 1)
  </code></pre>