Copying columns from webpage

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I'm trying to copy columns from an IE webpage and paste
into Excel 97. When I do that, all of the info pastes in
Column A and I need to use the "Text to Columns" feature
to spread the info out into the correct columns. I've
tried pasting it as "Text" and that doesn't seem to work.
This only happens periodically, it worked fine yesterday.
Any suggestions on what I can do? Thanks!
 
Once you have done Text to Columns once on data like that, Excel seems to
remember what you have done and repeat it for you when you paste in new data.
You might also want to consider using Data / Get External Data / New Web Query
to extract your data from the web page. Makes updating a breeze, and can even
be set to be automatic at set intervals.
 
Back
Top