Copy table from web to Excel 2003

[weid]

So I work with this web site and I always copy a table out of the web site goto excel 2003 and paste special text and it shows up in the correct columns an I can sort and use the data however I want.

Another person in my group does the exact same thing and it shows up in a single column... all the rows are there but each row has all the data in the first column so you can't sort or work with the data.

I'm sure there is some option field that he has or doesn't have set but have no idea where I should look.

Any ideas to guide us???
Thanks
John

[teylyn]

I believe this has to do with the settings in the Data - Text to columns dialog. If you paste something into Excel that ends up in one column, you can then parse it into cells with the Data - Text to columns and define what the delimiters for the cells are, e.g. comma, tab, or other characters.

The next time you paste something, Excel remembers the last settings used.

By the way, if you often grab the same table data from the web to put into Excel, you may want to check out Data - Import External Data - New Web Query, then navigate to the web site and specify the table to download. The next time you open the spreadsheet, you can determine whether or not to refresh the data straight from the web.

cheers