Hi

The wildcard for filenames would be "*" but I cannot imagine it would
work with a Hyperlink.
How would the hyperlink know what to do if there were 2 files in the
folder, Test.doc and Test.xls?

Rather than concatenating the ".pdf" or attempting to concatenate ".???"
or ".*", just make A1 the full name
Test.pdf and use
=HYPERLINK(CONCATENATE("G:\Research &
Resources\DATABASE\F",A1))

--
Regards

Roger Govier


"caramon2000" wrote in message
...
At the moment, I have a spreadsheet that is an index to filed
documents, with
a primary key of a number in column A. All the files are stored with
the
number of the file as the filename. Eg G:\Research &
Resources\DATABASE\F23.pdf. Assuming my data is in cell A1, If I use
the
formula =HYPERLINK(CONCATENATE("G:\Research &
Resources\DATABASE\F",A1,".pdf")), then it works well.

That's fine if they're all pdf documents, but there are excel
spreadsheets,
and jpeg files, word documents and even folders. Is there a way that
I can
get it to launch any or all things starting with what's what's in A1?
I
tried =HYPERLINK(CONCATENATE("G:\Research &
Resources\DATABASE\F",A1,".???"))
but it doesn't work. Any help would be much appreciated.