Formulas and hyperlinks
 

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?

Formulas and hyperlinks
 

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

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

Formulas and hyperlinks
 

What was in B2?

What happened when you clicked on that cell?

JeffPoulsen wrote:

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


--

Dave Peterson

Formulas and hyperlinks
 

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" wrote:

What was in B2?

What happened when you clicked on that cell?

JeffPoulsen wrote:

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


--

Dave Peterson

Formulas and hyperlinks
 

Glad it worked for you.

JeffPoulsen wrote:

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" wrote:

What was in B2?

What happened when you clicked on that cell?

JeffPoulsen wrote:

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


--

Dave Peterson


--

Dave Peterson