Menu
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?
982
The solution I have is to first get in edit mode of the cell (F2 or double click) and paste the first line followed by "Alt+Enter", paste the second line followed by "Alt+Enter", and so on until you're done.
Hold the Alt key while selecting it (this allows you to use marquee/table select), then copy and paste it into Excel. Oh thanks! That worked!
In Excel, if you copy some data from other file format and paste to a worksheet, then split the data by Text to Column function, then in next time when you paste data with a similar type to worksheet, the data will be automatically split to columns. Sometimes, you want to prevent the data being split.
This is an issue with Excel.
After you paste the results into Excel, go to the "data" option and choose "Text to Columns". Then click on "delimited" and be sure that "tab" is checked on the next window.
This will convert the data into columns. And, Excel remembers the settings, so it will paste correctly the next time.
134
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
