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.