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

2 Replies

  • 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