Hyperlink custom link_location formula

Question

I want to make custom link_location formula

= HYPERLINK("file:///C:\Users\PC\Desktop\File01.pdf", B1)

I have a column B where File01, File02,...... is listed.

I want to create hyperlink to locate the file on my Hard-disk with the same name as seen in above hyperlink.

How to Create a common hyperlink in column C where I don't have to change the file name manually. It will just take the value of Column B.

= HYPERLINK("file:///C:\Users\PC\Desktop\B1.pdf", B1)

score 0 · Accepted Answer · answered Dec 09 '13 at 11:55

0

Try:

=HYPERLINK("file:///C:\Users\PC\Desktop\" & B1 & ".pdf", B1)

answered Dec 09 '13 at 11:55

Gary's Student

1 Answers1