» 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:
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Excel 2002 Power Programming with VBA
- Financial Risk Manager Handbook, Second Edition
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Marketing Plan: A Handbook with Marketing Plan
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!

