Results copied from SSMS splitting across columns when pasted into Excel

Question

SSMS 2008 -> Excel 2003

This isn't happening all the time, but sometimes when I 'copy with headers' from sql server management studio, the results in Excel look as though I've used the 'text to columns' wizard with 'spaces' and 'brackets' as delimiters, meaning that the results become raggedly distributed across columns making them useless

I've looked in the 'grid output' query options but can't see anything which may be causing the issue

(not sure if this should be on superuser?)

Answer 1

It is persisting 'text to columns' settings from earlier

Workaround:
Find an empty cell
put asdf
in that cell

Data|Text to columns
delimited
uncheck all the options
finish up