ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   web data converted to Excel (https://www.excelbanter.com/excel-discussion-misc-queries/149856-web-data-converted-excel.html)

Medman

web data converted to Excel
 
How do I convert mass data such as address lists into Excel? I have lost my
info from doing this before and realize it is not a simple copy and paste
operation. Thanks

Gord Dibben

web data converted to Excel
 
Your question leaves many interpretations.

You copy and paste then manipulate into the order you want.

Manipulation depends upon how the dat is pasted into Excel.


Gord Dibben MS Excel MVP



On Wed, 11 Jul 2007 14:04:03 -0700, Medman
wrote:

How do I convert mass data such as address lists into Excel? I have lost my
info from doing this before and realize it is not a simple copy and paste
operation. Thanks



Gord Dibben

web data converted to Excel
 
Whoops..........left some off.

You may be able to use DataImport External DataNew Web Query


Gord

On Wed, 11 Jul 2007 16:12:41 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Your question leaves many interpretations.

You copy and paste then manipulate into the order you want.

Manipulation depends upon how the dat is pasted into Excel.


Gord Dibben MS Excel MVP



On Wed, 11 Jul 2007 14:04:03 -0700, Medman
wrote:

How do I convert mass data such as address lists into Excel? I have lost my
info from doing this before and realize it is not a simple copy and paste
operation. Thanks




All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com