Hyperlink Question

N

nastech

Hyperlinks such as: =HYPERLINK(

=HYPERLINK($A$1&B2,"3") works, but don't know how to fix:

=HYPERLINK("webaddress.com="&$A$1,"3") does not.

It goes to the web page, but tries to use: $A$1 as final symbol (not what
is in cell A1, which is desired)

How do I make the 2nd example work? Thanks
 
L

Leith Ross

Hello Nastech,

I suspect a typographical error is causing your problem. Recheck the
placement of the double quotes.

SIncerely,
Leith Ross
 
N

nastech

Thanks, got it. used your idea to check more. Familiar enough to know
should have worked, and had couple problems induced. I should have given a
full example.
something to laugh at anyways:

some =hyperlinks also had a previous link embedded (as in right-click, edit
type was present, ha)

other: links supplied address for was excluding prefix of "www." ouch
couldn't see that till first problem resolved... thanks
 
Top