Activce Hyperlinks

[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

 

[Gary''s Student]

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.

 

[Hardeep_kanwar]

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