Hi,

I have a spreadsheet (excel 2007) with 1000+ records.
Each record is numbered in Cells Column A.
Each record refers to a "job" undertaken.
Eg. Record #6472 = Job 6472-Cast Components.
Eg. Record #6473 = Job 6473-Machined Components.

Each "Job" is saved in a folder.
Eg. "E:\Enquiries\6400-6400\6472-Cast Components".
Eg. "E:\Enquiries\6400-6400\6473-Machined Components".

How can I write 1000+ Hyperlinks to open the Folders from the spreadsheet?

I have tried the following-

=HYPERLINK(CONCATENATE("E:\Enquiries\",LEFT(A165,2 ),"00-",LEFT(A165,2),"99\",A165),"Open Folder")

Cell A165 Contains "6472"

The above formula will return the path "E:\Enquiries\6400-6400\6472" and I
though I could use a wildcard "*" to accomodate the "-Cast Components" part
but it does not work

=HYPERLINK(CONCATENATE("E:\Enquiries\",LEFT(A165,2 ),"00-",LEFT(A165,2),"99\",A165,"*"),"Open Folder")

The above formula will return the path "E:\Enquiries\6400-6400\6472*"

Thank You in Advance,

Neil