Maybe it's how the browser puts the stuff in the clipboard.

I tried copying entire rows using Firefox 3.0.11 and all the rows went into a
single cell.

I tried copying entire rows using MSIE 7.x and it pasted very nicely.

What browser are you using?

I used xl2003 under WinXP Home, too.

Maybe those are important????

RNorfolk wrote:

Thanks for the reply, Dave.
I just tried a row as you had indicated, and it dropped all the numbers from
the 7 columns on the website into the cell I pasted into the first, not
across the cells.

I was able to take this table and do a text to columns, but that didn't work
for the table my user gets as the fields are vastly different widths, and not
comma or other delimited.

Thanks

Roger
--
Roger Norfolk
Office 97 MOUS Master

"Dave Peterson" wrote:

I used xl2003 to test and I copied entire rows of that table and pasted into A1
of a new worksheet.

And all the cells were properly populated--and so were the borders!

If you close excel and reopen it, then try the copy|paste, do things work ok?

Excel likes to help by remembering the choices you made from the last text to
columns.

If this doesn't help, maybe you could describe what happens in more detail.

RNorfolk wrote:

I have an example that best shows what I am trying to do. If you go to
http://www.ssa.gov/OACT/STATS/table4c6.html and select part of the table and
paste in Excel 2003 or 2007, the data does not go cleanly into the cells. If
pasted into Excel 97, it goes into each cell so it could be manipulated. Any
idea how to make 2003 paste into each cell?

p.s. this is an example. The data I am trying to make work is of varying
length fields that are not deliminated in any way when pasted. It does just
the same though.
--
Roger Norfolk
Office 97 MOUS Master

--

Dave Peterson


--

Dave Peterson