The second one is correct

=HYPERLINK(A2,B2)

with the URL in A2 and the name in B2

will return the name as a link to the URL


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"johnnstacy" wrote
in message ...

I'm thinking that it will need perhaps some variation of one of the
below formulas:

=hyperlink(concatenate("b12785,Q12785))

=hyperlink (B12785,Q12785)

But I haven't got it to work yet.


--
johnnstacy
------------------------------------------------------------------------
johnnstacy's Profile:
http://www.excelforum.com/member.php...o&userid=27302
View this thread: http://www.excelforum.com/showthread...hreadid=541294