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

[DeeRok]

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

[hoyasaxa215]

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.

[DeeRok]

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.

[hoyasaxa215]

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

[DeeRok]

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

[hoyasaxa215]

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