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 "(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

IC

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I email a hyperlink to a program file with a website as a parameter 13
Open specific hyperlink (accept) automatically in email with outlook 0
Extracting hyperlink from a cell 1
Creating multiple hyperlinks from a column where the text in the . 1
convert hyperlink to email address 24
How to prevent email addresses from becoming hyperlinks, and removinghyperlink 1
Converting Text To Email Addresses 3
Copy actual URL from hyperlink cell 3

Top