/ Published in: Visual Basic

Save the following code as a macro and then apply it to the fields you want to convert
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
Public Sub Convert_To_Hyperlinks() Dim Cell As Range For Each Cell In Intersect(Selection, ActiveSheet.UsedRange) If Cell <> "" Then ActiveSheet.Hyperlinks.Add Cell, Cell.Value End If Next End Sub
URL: http://www.jerryleventer.com/excel-tutorial-how-to-convert-plain-text-links-into-hyperlinks/
Comments
