add a Hyperlinks

I'm trying to add a hyperlink to the final outcome of:

=SUBSTITUTE(Info!$G$28,"village=99999","village=" & Z8)

I need to add the hyperlink to the value returned in the cell. The value ends up being something like: http://en28.tribalwars.net/game.php?...5&screen=place but it isn't a hyperlink. The hyperlink can either be like this: http://en28.tribalwars.net/game.php?...5&screen=place or like this

Thank you for any help recieved