title: SQL Server to Excel using Microsoft Query varchar not showing
body: <p>I have read a lot of posts that the simplest answer to the issue of special character is to replace your newline characters before running your query. I tried:</p>
  
  <pre><code>REPLACE(REPLACE(Field1, CHAR(10), ' '), CHAR(13), ' ')
  </code></pre>
  
  <p>I pasted the value into Notepad++ and there is no longer any special characters at least what I can see, I even did a TOP 1 to try only 1 row yet when I run the same query in the Microsoft Query Editor window in Excel the value comes out blank can any shed some light or direct me to another post answer I might have missed.</p>