=HYPERLINK("http://www.site.com/page.html?query=" & A1,A1)

Paul1 wrote:

Is there a way to make it just display the number and not the entire
URL?

--
Paul1
------------------------------------------------------------------------
Paul1's Profile: http://www.excelforum.com/member.php...o&userid=34428
View this thread: http://www.excelforum.com/showthread...hreadid=541945

--

Dave Peterson