Formulas and hyperlinks

[JeffPoulsen]

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]

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

 

[JeffPoulsen]

This did not create the url.

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

 

[Dave Peterson]

What was in B2?

What happened when you clicked on that cell?

 

[JeffPoulsen]

Dave,
I'm sorry I didn't have the formula you gave me entered exactly as you
had it. What you presented below worked fine. My mistake. I am glad you
returned even after giving me the correct answer the first time. If not I
may not have tried it again. I was in a hurry yesterday. Thanks for you help.
Jeff

 

[Dave Peterson]

Glad it worked for you.

Dave,
I'm sorry I didn't have the formula you gave me entered exactly as you
had it. What you presented below worked fine. My mistake. I am glad you
returned even after giving me the correct answer the first time. If not I
may not have tried it again. I was in a hurry yesterday. Thanks for you help.
Jeff