How can I overcome the HYPERLINK Functions 255 character limit?

Windows 11 now, and this is still a problem. I have a hyperlink formula on a data entry sheet, I can link to the data point address postcode on an internal mapping system, but I am limited to automatically opening only two additional map layers due to the 255 character limit. 

Metod 2 here doesn't work. I will try method 1 but I am not hopeful. Today I found a solution, basically create your greater than 255 characters url hyperlink in Word. Activate the url, with a space at the end or return. And copy and paste to a cell in Excel. 

This is only a manual solution. If you look at the link properties in Excel, the pop up menu is different to the native one in Excel. I can't seem to hold the Word formats in the cells and paste in the under 255 characters formula. 

Currently I have a helper hyperlink, above the table headers and the relevant column on the freeze pane, "Internal GIS with Useful layers. Copied from Word with about 900 characters. 

Solution was on http://www.mrexcel.com with a thread called /how-do-i-do-a-hyperlink-that-exceeds-255-chatacters-539414/