The best I've designed is below.  The reason I specifically called out name is because these are specific system objects that are created t install an not marked as MS...

• This reply was modified 3 years, 6 months ago by  jneal6927.

Go into Tools/Options/Query Results/SQL Server/Results to Grid - Check Retain CR/LF on copy or save.

That should ensure your Char(10)'s move into Excel when you copy/paste.

Elliott! That's exactly what I was looking for. I knew it was possible; just hadn't dug into it yet.

I'm going to take something like this and divide the...