excel

  • Thread starter Thread starter Brian
  • Start date Start date
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.
 
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
 
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.
 
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.
Click to expand...

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>
 
Back
Top