View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Geoff Geoff is offline
external usenet poster
 
Posts: 371
Default import data to excel

The problem comes about because of the format of the data on the webpage. Try
pasting, select column "A" and try Data - Text to Columns. This will bring up
a wizard which talks you though getting the data into the format you need.

Good luck
Geoff
--
There are 10 types of people in the world - those who understand binary and
those who don''''t.


"pacent" wrote:

1st I'm a novice so please explain accordingly. I've attempted to copy data
from a web page (www.usatoday.com/sports/sagarin/ftb06.htm) and paste onto an
excel worksheet (excel 2003 and/or 2000). The dialogue box informs me that
the copied info is not the same size as .... and after proceeding the data is
pasted into column A only. I'm seeking help that will enable this info to be
separated into columns that will allow me to paste the team names and their
associated ratings only and update this info on a weekly basis. welcome and
appreciate any and all help