Tip Printed from ExcelTip.com
Create a hyperlink from a string in Microsoft Excel
To create a hyperlink for a file path and name (for example), enter the
following text in cell A1: c:\ExcelTip\tips.xls
In cell A2, enter the following formula to create the hyperlink: =HYPERLINK(A1)