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