B
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.
a web page. The web page is set up with two different columns.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
If a repeated operation check out Data>Import External Data>New Web Query
Gord Dibben MS Excel MVP
S
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.
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.
R
Ragnar
Brian said: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>