Is it possible, for cell to show in another cell with a hyperlink form original cell.

I'm not sure if this is even possible but here goes.

I would like to add a product code "magic" in cell A1

I would then like the product code to appear in B1

B1 should be a hyperlink www.mydomain.co.uk/
and when A1 is populated the hyper link in B1 should be www.mydomain.co.uk/magic

Thank you for your response,

The function works great however in the cell B1 it now shows the whole URL
Is there a way for it to just show "magic" with the working URL attached?

If this is not possible please let me know so I will stop searching how to do it.
Kind regards
Simon