The problem stems from the fact that there are missing HTML elements, I'll explain below:
Opening the page, selecting all the links and pasting into Excel gives me this:
This is your problem. The HTML code of the page is like this:
Upon editing the code slightly, I then try copying the links again, pasting it into Excel results in this:
The edited code looks like this:
I cannot actually find the definitions of those classes, also the number 1 are seperate hyperlinks that are delimited through a non-existent spanning class without a breaking-line, upon inserting this breaking line in the code, it immediately works. Therefore we can isolate the problem, to being the lack of breaks between the links.
would not work, however something like this:
The reason this works in word but not excel is because excel cannot have more than one hyperlink in a cell. Excel uses the
<br> element to categorize each line in a different cell. So when you had 1, 2 without a breaking line in between, Excel would shove them in once cell, and there cannot be more than one hyperlink in one cell.
-Hope I helped, thanks. :D