Fun tidbit from a co-worker this week, very helpful if you’re not exporting right to Excel from the results context menu.
Under Tools > Options
- Expand Query Results > SQL Server > Results to Grid
- Tick Retain CR/LF on copy or save
- Restart SSMS
This will cause CR, LF, and CRLF to be treated as newlines when you copy a cell.