» Create a hyperlink from a string in Microsoft Excel
CATEGORY - Excel Worksheet, Workbook , Working with Formulas
VERSION - All Microsoft Excel Versions
In cell A2, enter the following formula to create the hyperlink: =HYPERLINK(A1)
Book Store:
Recommended Books:
- Accounting Principles, with CD, 6th Edition
- Microsoft Windows XP Inside Out
- Excel Charts
- Analyzing Markets, Products, and Marketing Plans
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
Stupid
Kay Fielding
This is really a useless hyperlink. What happens is that you paste in their website, and then you paste in the second part, and the word "Latest" comes up. No clue how to do it still.
helpful
Frank
thanks, are importing a comma delimited file with desription and filenames in it. (about 1000)
have put the excel file and all the images onto a cd. with the hyperlink can easily open the file from the spreadsheet, thanks!

