| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! | Excel Discussion (Misc queries) | |||
| Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) | |||
| Hyperlinks in Formulas | Excel Discussion (Misc queries) | |||
| Hyperlinks static but formulas are not. Why? | Excel Discussion (Misc queries) | |||
Linear Mode
