Copying data from Web Site to Excel spreadsheet

E

Elenora

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??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a dynamic master file 1
Copying Portions of Data 0
Cell data entering slow! 0
Paste to excel from word - auto format problem 1
Change a great number of words in word files, with a macro as short as possible. 5
How to paste this down? 3
Dumb question alert! What program to use? 0
Pasting a cell into bookmarked table from excel vba 1

Top