I have pdf files that have long, convuluted files names. As an example, [TABLE=”width: 375″]
[TR]
[TD]”445,046 Amolder,Klaus,,409291,09-02-2008.PDF” is the value of cell A2.
I am using the following formula in A3: =HYPERLINK(“P:KRAA2009″&A2&””,A2)
If I click on the hyperlink I get the message that the file cannot be opened. If I change the file name and the cell value of A2 to “test.pdf” the formula works fine.
I’m guessing the format of the file name is throwing off the formula. Are there any adjustments to the formula I can make to allow that file naming structure to work? [/TD]
[/TR]
[/TABLE]