title: Insert line break into SQL Query embedded in Excel Workbook Connection
body: <p><strong>Using:</strong> t-SQL, SSMS 2008, Excel 2010</p>
  
  <p><strong>Background:</strong> I have a SQL query that I've embedded into an Excel workbook via Connection that the end user can refresh. This query returns a column with a long string of sentences, basically a paragraph (this column's datatype is flexible).</p>
  
  <p><strong>What I Am Trying To Do:</strong> I would like each sentence of the paragraph to start on a new line in the Excel cell that it's in.</p>
  
  <p><strong>Example of UNDESIRED formatting:</strong>
  <a href="https://i.stack.imgur.com/5fzxa.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5fzxa.jpg" alt="enter image description here"></a></p>
  
  <p><strong>Example of DESIRED formatting:</strong>
  <a href="https://i.stack.imgur.com/1o1jN.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1o1jN.jpg" alt="enter image description here"></a></p>
  
  <p><strong>What I've Tried:</strong> I've tried adding the CHAR(13) linebreak to the SQL query. It correctly prints the paragraph with the desired line breaks in SSMS, but it doesn't transfer over to Excel, when the workbook is refreshed.</p>