Forum Discussion

Sandi241's avatar
Sandi241
Copper Contributor
Feb 17, 2021

Excel email links to view

I have an Excel spreadsheet with names that have a hyperlink for their emails.    I want to see the emails as a column, not just when I roll over or click.    Is their a way to do this? 
excel
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Feb 18, 2021

Sandi241 

Use the HYPERLINK function. It requires the arguments "HyperlinkAddress" and "Display name". Assume that your table contains the e-mail addresses in column A and the corresponding names in column B. The list starts on line 2, as in the following figure:

 

MailName
nikolino@nik.deNiko Lino
niko@nikolino.comLino Duo
niko@lino.comLino Italia
Nikolino@com.orgItalo niko

 

Then enter the following formula in the cell in which the hyperlink should appear (for example cell C2):

 

= HYPERLINK ("mailto:" & A2; B2)   in english : =HYPERLINK("mailto:"&A2,B2)

 

The addition "mailto:" means that your e-mail program is opened after clicking the hyperlink. The formula enters the email address behind it. You pass the text that is displayed in the cell with the argument B2.

Now simply drag this formula down and you will get a new column in which all mail addresses can be clicked immediately, as the add file shows: Open it

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 

Resources