| 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? |
| 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) | |||
Threaded Mode
