Pasting from SQL Server Management Studio to Excel concatenates columns

user_149945 0
Viewed 60453

I'm trying to paste my query results from Mgmt Studio to Excel, but for whatever reason the columns in Mgmt Studio are concatenated into a single column when pasted into Excel.

This doesn't happen to any of my colleagues and we couldn't find any settings for changing this. Any ideas?

paste concatenation sql-server-2008
5 Answers

I get this too and in the past i would shut down excel. I realized after a while that every day i do text to columns for a specific spreadsheet and i change the delimiter to other /. When i change it back to tab, it works fine.

user_147432960
Related