Launch Microsoft Excel and open the file in which you want to insert VBA code to control cut and paste operations. Click "File" on the Excel ribbon, then "Options" at the bottom of the menu.

Then use the Ctrl+V command to paste the text into a cell of your choosing in your Excel spreadsheet. The pasted text will retain the formatting from the website.