If A1 is your hyperlink and B1 contains the filename, cant you just use
=HYPERLINK(B1,B1)

Note, the first B1 reference is the actual 'url', the second B1 reference is
its 'friendly' name.

"Andy" wrote:

Hi

I have about 1000 excel files and i need to put a hyper link in each of them
to a differnt file on a network drive, the file name is the same as one of
the cells on worksheet.

Is there a way to include the text in the cell as part of the hyperlink text?

Andy