I am attempting to export some data from a table in our SQL Server DB into an Excel spreadsheet or to CSV. One of the columns in the table has commas in it. When I export the data (save it to a CSV file) using SQL Server Management Studio and then open the resulting file in Excel, the column with commas ends up in multiple columns. For example, if I export a row with "If we could all export data well, we wouldn't have to ask questions like this" in one of it's columns, the resulting CSV separates that string into two columns. The first contains "If we could all export data well". The second contains "we wouldn't have to ask questions like this".
How can I avoid this when exporting?