Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change list to hyperlinks
Hi Julia
Look on this site http://www.mvps.org/dmcritchie/excel...MakeHyperLinks -- Regards Ron de Bruin http://www.rondebruin.nl "Julia Chromicz" wrote in message ... I have several long lists in Excel of network files. Each cell includes the full path to the file. I need to change the list to hyperlinks using the "=hyperlink" function. For example... current value of cell C13 H:\Directory\File.xls desired value of cell C13 =hyperlink("H:\Directory\File.xls") Any ideas? Thanks! Julia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How would I change all hyperlinks at once? | Excel Discussion (Misc queries) | |||
Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
Change hyperlinks | Excel Discussion (Misc queries) | |||
change hyperlinks | Excel Discussion (Misc queries) | |||
Hyperlinks change | Excel Discussion (Misc queries) |