Stop mangling URLs containing a # so we can link to bookmarked content in a page or PDF from an Office document
When you create a URL containing a bookmark reference, e.g. a '#', MS Office mangles this by replacing it with %20-%20 ... that is ' - '.
This problem is often encountered by users making extra effort to make it easier for people to find specific content. It is often used to refer to a specific page in a PDF document. But this 'feature' of Office is counter intuitive and counter productive.
This 'feature' is documented by Microsoft here: https://support.microsoft.com/en-au/help/202261/you-cannot-use-a-pound-character-in-a-file-name-for-a-hyperlink-in-an
This issue has been viewed 14,292 times on Stack Overflow here:
Does adding a question mark as proposed here fix this? Seems to work for me...
In 2020 this is shameful
Alistair Sutter commented
In 2019 this is shameful.
The easiest solution is to create a tiny URL from the URL containing the hashtag / pound sign and embed this URL in MS Office.
It was a problem in Office 2010, and they haven't bothered to fix it in 365......
They even give you functionality to add reference to bookmarks in the target document, which inserts the # for you!!
Jaka Ivančič commented
I simply can not believe how is it possible that this limitaion exists.