How about:
=hyperlink("http://mysite/logs/" & b2 & "logs.htm","Click Me")



JeffPoulsen wrote:

I have created formula to create a url using the information from one cell "B2"
=CONCATENATE("http://mysite/Logs/",B2,"logs.htm")
This works to create the following:
http://mysite/Logs/namelogs.htm
The problem is when you hover on the link in the field or click it it wants
to go to the formula or
http://mysite/Logs/",B2,"logs.htm
How can I fix this?

--

Dave Peterson