Hello all - when i copy and paste table data from this site into excel, all the data goes in Column A. I've tried many different things and still can't get it to work.
Let me know if there's anything I can do. Thanks!
Here's the site:
http://www.nhl.com/stats/team?aggreg...ed,gte,1&sort=
Hi goof and welcome to the forum,
Some websites use a background database to display stuff, instead of making a normal web table. It looks like you have one of those. How about trying to print this site to a Text or CSV file and then import it into Excel?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks! When you say "print" do you mean?
I have clicked on "print" and pasted from the print preview and getting closer... what do you mean by printing to a CSV file?
thanks again
Hi,
Depending on what printers you have installed on your system, when you print stuff it asks what printer you want to print to. I get a list of about 5 different printers when I use that web site and tell it to print. If you have a printer called "Text File" you would print to that. Then it will ask for a filename which you supply. Then try to import that file into Excel.
If you would fill in more of your user profile, I might see which version of Excel you have and/or your OS. The answers will change with each.
Here is what I'd do for my OS:
http://www.kbytes.co.uk/Articles.asp?articleid=58
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks