将大量数据粘贴到Excel中

I have a query that I run in SQL Server using Management Studio. The results are output to the grid that I then copy and paste to Excel sheet that gets saved in .csv format. I've never had any problem doing this before but this one particular query includes a column that contains a large chunk of HTML (several thousand char.). If I try to paste the entire query output into excel it can't handle that column and the sheet is unusable.I have a query that I run in SQL Server using M