How do I convert a column of cells with text emails to hyperlink to email ...

G

G Vandevalk

I have a column with text emails in it of the text form "[email protected]"
I wish to convert the entire row to hyperlinks to email ...

If I click on "HYPERLINK" and then select email it gives this hyperlink the
text name
of [email protected] and asks me to type in the email ... argh...

-- Gerry
 
D

Dave Peterson

I think I'd insert another column and use a formula like:

=hyperlink("mailto:"&a1)

and drag down.

Hide the original column if you don't want to see it.
 
Top