Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering emails without hyperlink creation | Excel Discussion (Misc queries) | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
Removing hyperlink | Excel Discussion (Misc queries) | |||
Hyperlink Creation in Excel X for Mac | Excel Worksheet Functions |