Link to home
Create AccountLog in
Avatar of KANEDA 0149
KANEDA 0149Flag for United States of America

asked on

Excle 2013 Paste Data as Comma Delimited

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?
ASKER CERTIFIED SOLUTION
Avatar of gplana
gplana
Flag of Spain image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
More information about text-to-columns in here: http://support.microsoft.com/kb/214261
Avatar of KANEDA 0149

ASKER

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.
Thank you both for your feedback!