Activate email hyperlinks in imported data

0

02driver

Software: Excel 2003
I've received a spreadsheet containing various email addresses but the
hyperlink for each address is not active (regular text, not marked as
hyperlink). When I double click on the individual email address then move to
the next cell, the email address hyperlink becomes active (address displays
blue with underline). Is there a way to activate the hyperlink for multiple
cells?
 
G

Gary''s Student

If A1 contains:
(e-mail address removed) as a "cold"cell, then in the next column:

=HYPERLINK("mailto:" & A1) for a nice "clickable" link
 

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

Top