clickable URL in excel?

[djarcadian]

I'm using the following code to create a Google URL

="http://www.google.com/search?q=" & D16 & " " & D17

but it only displays the URL as text. Is there a way to make this URL clickable so it launches this URL in a web browser?

[Don Guillett]

try

=hyperlink("http://www.google.com/search?q=" & D16 & " " & D17)

--
Don Guillett
SalesAid Software
[email protected]
"djarcadian" <[email protected]> wrote
in message news:[email protected]...
>
> I'm using the following code to create a Google URL
>
> ="http://www.google.com/search?q=" & D16 & " " & D17
>
> but it only displays the URL as text. Is there a way to make this URL
> clickable so it launches this URL in a web browser?
>
>
> --
> djarcadian
> ------------------------------------------------------------------------
> djarcadian's Profile:
> http://www.excelforum.com/member.php...o&userid=15877
> View this thread: http://www.excelforum.com/showthread...hreadid=546865
>

[djarcadian]

Thanks! That worked.

[Don Guillett]

glad to help

--
Don Guillett
SalesAid Software
[email protected]
"djarcadian" <[email protected]> wrote
in message news:[email protected]...
>
> Thanks! That worked.
>
>
> --
> djarcadian
> ------------------------------------------------------------------------
> djarcadian's Profile:
> http://www.excelforum.com/member.php...o&userid=15877
> View this thread: http://www.excelforum.com/showthread...hreadid=546865
>