As you anyway are coping data manually from web page, the simplest way is:
Have an empty sheet, and paste your data there;
Copy data you just pasted, and PasteSpecial them as values into your table (be sure columns there are formatted properly);
Clear all data from another sheet, so they don't mess you up when you get your next batch of data from web.
|