Copy paste website source code

Temporary-Failure

Board Regular
Joined
Jul 16, 2010
Messages
140
I copy website source code and paste it to excel just ctrl-c, ctrl-v. It paste fine and there aren't any website rendering, just plain text as source code is. There are about 800 rows. But pasting is slow. It takes about 5 seconds to paste. I have no macros running and tried also calculation in manual but it doesn't help. What I can do to speed up pasting?
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

As it can't be 'speed up' the question is why needing to paste a webpage code within Excel ?‼​
Try in Notepad or any text editor …​
 
Upvote 0
So paste the webpage code first to any text editor …​
 
Upvote 0

As it should be faster, then copy only the necessary to Excel from the text editor …​
 
Upvote 0
download notepad++, paste code into a tab on there, save that tab as .html or .htm and it will read the code as if you were in a html editor.
 

Attachments

  • notepad-example.JPG
    notepad-example.JPG
    115.7 KB · Views: 13
Upvote 0

Forum statistics

Threads
1,224,743
Messages
6,180,686
Members
452,994
Latest member
Janick

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top