Hyperlink Function Problem

P

Peter Ramm

I am having a problem with the hyperlink function.

Say b2 contains =HYPERLINK("A1","test")

clicking on b2 produces the error message: "The address of this site
is not valid. Check the address and try again"

--
Pete Ramm
[email protected]

Stamp out Spam - See my anti-spam pages:
http://www.spamfreezone.org
 
P

PCLIVE

If you have a link reference in cell A1, then remove the quotes from A1 in
your formula.
=HYPERLINK(A1,"test")
 
P

Peter Ramm

If you have a link reference in cell A1, then remove the quotes from A1 in
your formula.
=HYPERLINK(A1,"test")
Click to expand...

Have you tried that.
That is at odds with Help on Hyperlink function - "Link_location can
be a text string enclosed in quotation marks or a cell that contains
the link as a text string." - and it doesn't work for me
--
Pete Ramm
[email protected]

Stamp out Spam - See my anti-spam pages:
http://www.spamfreezone.org
 
D

Dave Peterson

What's the text in A1?

Maybe you need:

=hyperlink("http://" & a1, "test")
 
Top