How to convert tex to clickable email address? (2002)

Topic

New Reply

I have several columns of imported email address. I believed they are in text format. How to convert them into clickable email address?

Reply | Quote

Replies

Select the cells containing the addresses and run this macro:

Public Sub ConvertToEmail()
Dim oCell As Range
    For Each oCell In Selection
        ActiveSheet.Hyperlinks.Add anchor:=oCell, Address:="mailto:" & oCell.Value
    Next oCell
End Sub

Reply | Quote

If A1 has an email address, then the formula

=HYPERLINK("mailto:"&A1,A1)

will create a clickable link.

Reply | Quote