Copy/Pasting data from SQL Server to Excel splits up text into multiple columns?
If you've used Text to columns recently, it will apply those settings to the Paste operation. I don't remember this happening before Excel 2007, but it may have. I always have to go back and set it back to tab delimited before I start copying and pasting again.
Before pasting the results: Data → Text to Columns
- Original Data Type: Check Delimited
- Next
- Delimiters: Uncheck Space
- Next
- Finish
Finally paste the results.