Creating URL links using a formula

[Dan Morris]

If
A1 = John
B1 = Bloggs<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
How do I make
C1 = a hyperlink to a file in the format "D:\files\John Bloggs" which I can then click to access John Blogg's files.<o></o>
<o></o>
I got as far as<o></o>
=CONCATENATE("D:\files\",A1," ",B1)<o></o>
but it wouldn't hyperlink to the file structure it had created<o></o>
<o></o>
Can you help?

 

[texasaswang]

=HYPERLINK(""D:\files\" & A1 & " " & B1","File")

 

[Dan Morris]

Thanks for your help.

=HYPERLINK(""D:\files\" & A1 & " " & B1","File")