Excle 2013 Paste Data as Comma Delimited

KANEDA 0149
KANEDA 0149 used Ask the Experts™
on
I am trying to copy/paste SSMS 2008 results into Excel 2013 but it paste as comma delimited instead of tab delimited.  Is there a setting in Excel 2013 which changes this default setting.  The old Excel 2013 automatically does the tab delimited.  I know I can use double quotes in my SQL syntax to get around but I am more looking for a setting in Excel 2013.  Can I change the registry?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Use text to columns after pasting it into the sheet. You can then split the text by delimiter (e.g. space or tab).
You should still have the option File > "Save as" to chose a tab-delimited format for saving the file. Alternatively instead of copying and pasting the result from SSMS to Excel, use SSSI or SQL Import/Export DTS utility and select a flat file destination, where you can chose the column delimiter to be a tab.
More information about text-to-columns in here: http://support.microsoft.com/kb/214261

Author

Commented:
So there is no setting in Excel 2013 to revert the default setting back to tab delimited?  

I guess I was just trying to make the copy/paste simple versuses have to "save as" or add double quotes to contain my SQL results since some of the data contains comma; therefore if I did the text to columns it would still split it and treat it like a deliminator.

Author

Commented:
Thank you both for your feedback!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial