Posted By

kidmizere on 03/07/12

Tagged

excel

Versions (?)

Last Edited at 03/07/12 03:00pm

Statistics

Viewed 1157 times

Favorited by 0 user(s)

Related snippets

Convert Excel plain text links to hyperlinks

/ 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/

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.