Trying to copy/paste data from table on website, pasting into excel improperly

I am trying to copy/paste data from a table on a website into excel. On the site it looks like this:

Please Login or Register  to view this content.

When I paste it into excel, it comes out:

Please Login or Register  to view this content.

If I paste as unicode instead of HTML, it comes out:

A1A2A3A4 (no space or any break between them)
B1B2B3B4

Any ideas on how to get this to paste properly?

Thanks

What's the website? One option may be to use Data > From Web and create a link to the site through excel and it will automatically (and hopefully, correctly) import the data into excel for you.

I tried using that feature and it doesn't work. For some reason it gives a javascript error and won't even load the page.

Then may make sense to paste the unicode results and then use the Text to Columns feature with the fixed width option.

I can do that but I'd have to do it individually for each row since the rows are different widths. I guess it may be the only option though. Thanks

Is it always two characters that you want in each cell? If so, there may be formulas you can use to accomplish that.