add a Hyperlinks

[dextras]

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

[DonkeyOte]

use the HYPERLINK function:

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

(where "this" is friendly name of link)

[dextras]

^ Lol, ty. +1 I tried that but must have done something wrong lol. Ah, I no, i used the = again for after substitute. why did you use a bracket? are there only allowed to be 1 = in a cell?

[DonkeyOte]

are there only allowed to be 1 = in a cell?

Correct....