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?
|