My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Converting delimited, csv, fixed width text to columns in Excel
The new RSS feed is here
If you've ever worked with tables of text data you must have tried to copy data from a file or other place into excel and it all gets dumped in one column. You know its nicely delimited by commas or tabs or may be its fixed width and excel can convert this data into columns when you open a file so why can't excel translate the data into columns when you paste.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Converting delimited, csv, fixed width text to columns in Excel