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

  • Thread starter Thread starter G Vandevalk
  • Start date Start date
G

G Vandevalk

I have a column with text emails in it of the text form "(e-mail address removed)"
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 (e-mail address removed) and asks me to type in the email ... argh...

-- Gerry
 
I don't know if there's a quicker way, but one way is to double-click on
each cell with the text in, then press enter, or click the green tick.

Ian
 
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.
 
Back
Top