Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Hyperlink result as working hyperlink
Hi! I have a column of over 700 filepaths.
I have a column which turns those paths into hyperlinks: =hyperlink("http://tbuk/"$B3) These links work. I want a single column that doesn't refer to the filepath, so I am trying to replace the hyperlink formulae with the result as a hyperlink. When I copy and paste, it seems to paste the result, but the link doesn't work (though it still has the style of a link: blue underlined). Is there a way to avoid having to press F2, Enter for every one? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Hyperlink result as working hyperlink
On Thu, 21 Jan 2010 12:03:01 -0800, Bod
wrote: Hi! I have a column of over 700 filepaths. I have a column which turns those paths into hyperlinks: =hyperlink("http://tbuk/"$B3) These links work. I want a single column that doesn't refer to the filepath, so I am trying to replace the hyperlink formulae with the result as a hyperlink. When I copy and paste, it seems to paste the result, but the link doesn't work (though it still has the style of a link: blue underlined). Is there a way to avoid having to press F2, Enter for every one? If you get a finger pointer mouse cursor change when you hover over it, it is a hyperlink, and should evoke your browser, regardless of whether it is even a valid link or not, and try to "go there".. So try it. Paste in a valid directory pointer as a link and see if it will take you there. If so, then maybe there is a problem with the pasted link syntax somehow with your data set. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Hyperlink result as working hyperlink
On Thu, 21 Jan 2010 12:03:01 -0800, Bod
wrote: Hi! I have a column of over 700 filepaths. I have a column which turns those paths into hyperlinks: =hyperlink("http://tbuk/"$B3) These links work. I want a single column that doesn't refer to the filepath, so I am trying to replace the hyperlink formulae with the result as a hyperlink. When I copy and paste, it seems to paste the result, but the link doesn't work (though it still has the style of a link: blue underlined). Is there a way to avoid having to press F2, Enter for every one? Right click on one and select "edit hyperlink" and see what the actual hyperlink syntax is there, because the visible string can say "up-yers" and the inside is where the real pointer is at so the "link" takes you to a different place than the actual text that appears. That is so you can name the link, as in "Go To Home Page" or such, and the underlying true link is the one that actually gets referred to. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink to PDF not working | Excel Discussion (Misc queries) | |||
VLookup result to be an active hyperlink | Links and Linking in Excel | |||
Hyperlink not working... | Excel Worksheet Functions | |||
Excel hyperlink not working | Excel Discussion (Misc queries) | |||
Hyperlink stops working | Excel Worksheet Functions |