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:



then in B1, enter:

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

This will create nice, "clickable", hyperlinks.

--
Gary''s Student - gsnu200824


"Hardeep_kanwar" wrote:

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

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

"Gary''s Student" wrote:

Suppose column A has material like:



then in B1, enter:

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

This will create nice, "clickable", hyperlinks.

--
Gary''s Student - gsnu200824


"Hardeep_kanwar" wrote:

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