title: Identifying text strings that are problematic when pasting from SQL Server MS 2012 into Excel
body: <p>A lot of the front end user's don't give a rat's ass about data input quality. My SSMS query retrieves the data beautifully with the correct number of rows output, as expected. 
  <a href="https://i.stack.imgur.com/uYhx2.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uYhx2.jpg" alt="enter image description here"></a></p>
  
  <p>On pasting into Excel you get a different number of rows and the set needs playing around with. I believe it's because the data input in that field is weird / non-standard. </p>
  
  <p><a href="https://i.stack.imgur.com/43naJ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/43naJ.jpg" alt="enter image description here"></a></p>
  
  <p>Is the only way to fix this editing the source data or making a big exception clause? I don't want to go via csv and text to columns either.</p>