View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Elenora Elenora is offline
external usenet poster
 
Posts: 1
Default Copying data from Web Site to Excel spreadsheet

Bonjour,

I need to do the following, and I am trying to find the fastest way in doing
it.

1- Copy collums of add. from a web page.
2- Paste inside an Excel speadsheet.
3- Collums have to be paste in 1 horizontal row, ie. name, add, tel. number
etc.

I have tried the Data transfer function, and for some reason it does not
work. I have a program to which I can copy the data from the web, which
automaticly turns it to Text.
Once the data is in the text format, I have to clean out the 'crap" data,
then copy paste to excel. What I am trying to find is a program, that will
turn the text to a CSV format, so that I do not need to clean the data again
inside of excel!

Making sense??