excel - Hyperlink custom link_location formula

Question

I want to make custom link_location formula

= HYPERLINK("file:///C:UsersPCDesktopFile01.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:UsersPCDesktopB1.pdf", B1)

Answer 1

Try:

=HYPERLINK("file:///C:UsersPCDesktop" & B1 & ".pdf", B1)