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)