Activce Hyperlinks

  • Thread starter Thread starter Hardeep_kanwar
  • Start date Start date
H

Hardeep_kanwar

Hi! Expert

I have a 5000 E-Mail IDs in on column. Now want to Active these Email Ids.

How Can i Active These Email ID With just one Click

or i have to press F2

Thanks In Advance

Hardeep kanwar
 
Suppose column A has material like:

(e-mail address removed)

then in B1, enter:

=HYPERLINK("mailto:" & A1) and copy down.

This will create nice, "clickable", hyperlinks.
 
Thanks Gary''s

It Works fine for me

but is there any way without using Formulas. I mean to say in the Simple way
that we use for pressing F2 or Double Click and then Enter Because with this
function i have to Add another column in my sheet


Thanks

Hardeep kanwar
 
Back
Top