Automating hyperlink creation
 

I have one column with file names. The web addresses for all of these files
are the same with the exception of the file name itself. How can I automate
creating hyperlinks in a different column for these files?

Column A - 123456789 - 987654321
Column B - http://www.testsite.com/pdf's/123456789.pdf -
http://www.testsite.com/pdf's/987654321.pdf

Steve Williams

Try this:
=HYPERLINK("http://www.testsite.com/pdf's/"&A1&".pdf",FriendlyName) ,
where FriendlyName is a reference to the text you want displayed in
the HyperLink cell.
hth,
ScottO


"Steve Williams" wrote in message
...
| I have one column with file names. The web addresses for all of
these files
| are the same with the exception of the file name itself. How can I
automate
| creating hyperlinks in a different column for these files?
|
| Column A - 123456789 - 987654321
| Column B - http://www.testsite.com/pdf's/123456789.pdf -
| http://www.testsite.com/pdf's/987654321.pdf
|
| Steve Williams
|
|