clickable URL in excel?
 

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

clickable URL in excel?
 

try

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

--
Don Guillett
SalesAid Software

"djarcadian" wrote
in message ...

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

clickable URL in excel?
 

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

clickable URL in excel?
 

glad to help

--
Don Guillett
SalesAid Software

"djarcadian" wrote
in message ...

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