![]() |
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?? |
All times are GMT +1. The time now is 04:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com