Column wrapping when Copy&Paste or export data from SQL Server to Excel with large string column
I have a MS SQL SERVER query that I run. One of the field/columns is huge. Called Raw_Results If the results are say 1200-1400 characters long and.......
and I need to export them to a file in excel. Current version. How could I do that cleanly.
Why because the results of that column wrap on export. Thus messing up the file because I cant get clean columns.
Is there a way in SQL or EXCEL that might correct that. I heard that there might be a CHAR(??) function or something that might do it or maybe some setting in excel or in the SQL Export tool that can solve this problem?
Yes there may be some carriage returns in there but I am not sure how to check that other than copy the record out and past it and try to find it to see if I can find one.
I will try all the others options.
The copy & paste seems to be the most problematic. I could not find Tab-Delimiter feature in the SQL export does not seem to be obvious. These look like all good solutions I will try them. Thank you all.