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

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

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

"G Vandevalk" <[email protected]> wrote in message
news:[email protected]...
>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
>
>

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.

G Vandevalk wrote:
>
> 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

--

Dave Peterson