| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting a value as an hyperlink
I have imported a list from a database of file paths to documents on our
server, these data is currently formatted as 'General' Is there anyway of converting that value into a hyperlink to the said documents? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pasting a value as an hyperlink
If your list is the complete path and file name, then in an adjacent
column you could just do: =HYPERLINK(A1) and copy this down. If you wish to you could fix the values and then you would not need column A. Hope this helps. Pete On Apr 20, 4:14*pm, The Rook wrote: I have imported a list from a database of file paths to documents on our server, these data is currently formatted as 'General' Is there anyway of converting that value into a hyperlink to the said documents? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why lose hyperlink when copying and pasting? | Excel Discussion (Misc queries) | |||
| Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
| Remove hyperlink when pasting | Links and Linking in Excel | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
| Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
![The Rook[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
