Dan Morris
New Member
- Joined
- May 22, 2012
- Messages
- 37
- Office Version
- 365
- Platform
- Windows
If
A1 = John
B1 = Bloggs<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><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?
A1 = John
B1 = Bloggs<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><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?
