Inserting cell contents to a hyperlink location

[austinquestel]

Hi,

I am trying to add hyperlinks to each cell in a column to this directory (C:\Documents and Settings\aenglert.QUESTEL\Desktop\OCRed) where the cell contents are the names of the files.

So cell A1 = US7442200 and I want the hyperlink to lead to the following location: C:\Documents and Settings\aenglert.QUESTEL\Desktop\OCRed\US7442200.pdf

Help PLEASE!

Thanks very much...

 

[Georgiboy]

You could use =Hyperlink function in Excel for instance:

=HYPERLINK(Your link goes here & "\" & A1) ' A1 is the cell reference

This will add the text you want to the current link.

hope this helps

 

[austinquestel]

I'm still having trouble...I'm using the formula that you suggested- now I'm getting the following error in the cell:
#NAME?

What am I doing wrong?

 

[Georgiboy]

try =HYPERLINK(C:\Documents and Settings\aenglert.QUESTEL\Desktop\OCRed & "\" & A1 & ".pdf")

what version of excel are you using?

 

[austinquestel]

Excel 2003.
I tried that too, got the same error message.
The closest I have been able to come is using:

=HYPERLINK("C:\Documents and Settings\aenglert.QUESTEL\Desktop\OCRed & \ & A2 & .pdf ", A2)

This gives the correct name in the linked cell, but when I click to open the linked pdf, I get a popup error saying "Cannot open the specified file".

 

[Georgiboy]

=HYPERLINK("C:\Documents and Settings\aenglert.QUESTEL\Desktop\OCRed" & "\" & A2 & ".pdf ")

 

[austinquestel]

That did it!

Thanks very much for your help; I really appreciate it...