Sök i support

Akta dig för supportbedrägerier: Vi kommer aldrig att be dig att ringa eller skicka ett sms till ett telefonnummer eller dela personlig information. Rapportera misstänkt aktivitet med alternativet "Rapportera missbruk".

Läs mer

Inserting a table in a webpage into an identically organized table in Excel

  • 1 svar
  • 1 har detta problem
  • 1 visning
  • Senaste svar av TonyE

more options

A web page I accessed has information supplied via a table. Is there a way I can have it appear in an Excel spreadsheet just as it is on the web page? Some web sites provide a direct transfer into Excel. This web page does not. It would require an inordinate amount of time to take the data an place it in individual Excel cells, as it appears in the web page.

A web page I accessed has information supplied via a table. Is there a way I can have it appear in an Excel spreadsheet just as it is on the web page? Some web sites provide a direct transfer into Excel. This web page does not. It would require an inordinate amount of time to take the data an place it in individual Excel cells, as it appears in the web page.

Alla svar (1)

more options

If using copy and paste, in Excel you can use Paste Special and choose the Unicode text option. Another option is to use the Dafizilla Table2Clipboard extension to copy the table.

Ändrad av TonyE