Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
creating hyperlinks
I have a large column of names which I want to change into hyperlinks.
The link should open a file which name is the same as the content of the cell, only it has an extension added. The file is located in the same directory as the excel file. F.e. lets say the contents of cell A1 is "contentA1". Now cell A1 should be changed into a hyperlink that opens file 'contentA1.ext' on clicking it. One cell is easy to do, but I have hundreds of them and would like to automate this in some way. Thanks. -- Posted on news://freenews.netfront.net - Complaints to -- |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
creating hyperlinks
You could use an adjacent cell and a formula:
=hyperlink("file:////C:\somepath\" & a1 & ".ext", "Click me") Or put the path in a different cell and use a formula like: =hyperlink("file:////" & $x$99 & a1 & ".ext", "Click me") David Baker wrote: I have a large column of names which I want to change into hyperlinks. The link should open a file which name is the same as the content of the cell, only it has an extension added. The file is located in the same directory as the excel file. F.e. lets say the contents of cell A1 is "contentA1". Now cell A1 should be changed into a hyperlink that opens file 'contentA1.ext' on clicking it. One cell is easy to do, but I have hundreds of them and would like to automate this in some way. Thanks. -- Posted on news://freenews.netfront.net - Complaints to -- -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
creating hyperlinks
Hi David
Are The Names in Column A AND What Column is Available for A column Of Hyperlinks Best Stew "David Baker" wrote: I have a large column of names which I want to change into hyperlinks. The link should open a file which name is the same as the content of the cell, only it has an extension added. The file is located in the same directory as the excel file. F.e. lets say the contents of cell A1 is "contentA1". Now cell A1 should be changed into a hyperlink that opens file 'contentA1.ext' on clicking it. One cell is easy to do, but I have hundreds of them and would like to automate this in some way. Thanks. -- Posted on news://freenews.netfront.net - Complaints to -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating many hyperlinks at a time | Excel Discussion (Misc queries) | |||
Creating hyperlinks | Excel Discussion (Misc queries) | |||
Self creating Hyperlinks HELP PLS | Excel Discussion (Misc queries) | |||
creating hyperlinks to email | Excel Discussion (Misc queries) | |||
creating hyperlinks | Excel Worksheet Functions |