excel

[Brian]

I am try to see if there is an easier way to copy and paste address from
a web page. The web page is set up with two different columns.

 

[Gord Dibben]

If the operation is a one-off probably easiest is to copy/paste to Excel.

If a repeated operation check out Data>Import External Data>New Web Query


Gord Dibben MS Excel MVP

 

[ShaneDevenshire]

Hi,

If the problem is that if you copy both columns of data they end up in one
column, then the usual solution is to highlight and copy both columns, move
to Excel and paste them. Then choose the command Data, Text to Column and
follow the instructions in the wizard.


If this helps click the Yes button.

 

[Ragnar]

I am try to see if there is an easier way to copy and paste address from a
web page. The web page is set up with two different columns.

Not completely sure what you mean BUT often if I want to copy columns or
tables from web pages (or PDF documents) I paste into Word first, where it
appears as a table. Then I can copy and paste the table into Excel.

HTH
R>