maybe you can try

=hyperlink(concatenate(B1,C1,D1,A1,E1))

in B1 you would store the initial part of the path i'm assuming it's
"G:\\research"

then in C1 you would store "\resources"

in D1 it is "\DATABASE\F"

in A1 i'm assuming that you store the filename number let it be
"filename_number"

in E1 you should sotore the extension of the file you want to open with the
dot included eg ".xls",".doc",".xml", etc.

the final result should aproach this: "
G:\\research\resources\DATABASE\Ffilename_number.p df "




just one final question on the path of the files, the "F" part isn't another
folder?

because if it is then this correction must be applied

in D1 it is "\DATABASE\F\"


--
---
zz [MX]
cuasi-musico,semi-poeta y loco


"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. Does this mean that I can't use wildcards in
formulas?
Is there any other way around this problem so that it will launch any file
in
the correct folder starteing with the number in A1? Any help would be much
appreciated.