Fix Hyperlinks in Column 1 of Tables
Hyperlinks with fewer than 4 display characters, that are contained in column 1 table cells do not work. The little palm that is expected to show up when hovering the mouse cursor does not appear.
To see issue, create an empty table, then add the following formula to the first row in the first column:
Experimentation shows it must be a somewhat different thing than you are deducing.
When I do exactly as you say, I indeed cannot even click on the single letter "friendly" name. But that's because there is this arrow beastie for my cursor that is entirely reminiscent of the cursor change that is so annoyingly hard to get when trying to slect a table row in Word. (You have like a 2 pixel wide spot to see it. Maybe that's hyperbole, but not by much.)
So I get that for 1-2 characters of friendly name, but at about 3, and almost always by 4 characters (not with 4 "l" (lower case "L") characters), I can click on a bit of it and get the hyperlink action.
More tellingly, if I use a single "l" character but format the cell to indent by three (three "whatever" Excel indents by), the friendly name is moved far enough right in the cell that I CAN select the friendly name and go to the desired place.
Another telling point is that if I do this with no Table, just a cell picked out of the blue, there is no strange cursor and no difficulty at all.
So it is clearly an issue with Table programming in particular, not the hyperlink function. Needs fixing. Given that cursor and that (theoretically) how one gets it in Word when trying to select full rows or columns in a... wait for it... Table, it suggests Excel programmers did not make a solid effort with Tables, rather opting for doing some minimum to adapt Table funcitonality that Word already had programmed.
Admirable, the connection so as to make the two heavyweights more interactive, one supposes, but not so much admirable the laziness or incompetence.
Meanwhile, whatever the cause, it does need fixing!