How to use a hyperlink to a webbrowser which includes ampersand (&) in its name?

[Sabilica]

I am currently in the midst of making a small library of links in Microsoft Team Excel. Where I have met a wall, where I cannot use the link, as they are redirected due to the including ampersand in the title. Example:

xxxxxx.com/xxx/xxx/?action=show&product=301

Which is translated to;

xxxxxx.com/xxx/xxx/?action=show&product=301



So how am I supposed to get around that.



I have seen a lot of examples of but renaming the destination (which is not a valid option), and using and encoding reference, which does not seem to apply for this context.



Currently the formula I am dealing with is: =HYPERLINK(H14;$F$1);

‘H14’ being the hyperlink, and ‘F1’ being the visual name.

 

[smozgur]

Welcome to the MrExcel Message Board!

I didn't understand why the URL string is translated/encoded, however, if H14 contains the URL with encoded version of the ampersand symbol, then you can use SUBSTITUTE function to replace it in the HYPERLINK function:

=HYPERLINK(SUBSTITUTE(H14,"&","&"), $F$1)

 

[Sabilica]

Thanks for your response Smozgur!

Unfortanetely it does not work, as it seems as if the Team-version of Excel are encoding the hyperlink after you click on the link - rather than after the excel function. It does however work perfectly in regular excel.

So it still does not work, as the link is always translate "&" to "&", as long as it is opened directly through Teams.