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:
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.