View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
JeffPoulsen JeffPoulsen is offline
external usenet poster
 
Posts: 3
Default Formulas and hyperlinks

This did not create the url.

"Dave Peterson" wrote:

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