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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
gplana
More information about text-to-columns in here: http://support.microsoft.com/kb/214261
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.
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.
ASKER
Thank you both for your feedback!