ExcelBanter - Pasting a value as an hyperlink

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pasting a value as an hyperlink (https://www.excelbanter.com/excel-discussion-misc-queries/261948-pasting-value-hyperlink.html)

The Rook[_2_]

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?

Pete_UK

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?

All times are GMT +1. The time now is 02:32 AM.