Excel email links to view

%3CLINGO-SUB%20id%3D%22lingo-sub-2144511%22%20slang%3D%22en-US%22%3EExcel%20email%20links%20to%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2144511%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20Excel%20spreadsheet%20with%20names%20that%20have%20a%20hyperlink%20for%20their%20emails.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20see%20the%20emails%20as%20a%20column%2C%20not%20just%20when%20I%20roll%20over%20or%20click.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20their%20a%20way%20to%20do%20this%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2144511%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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? 

2 Replies

@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.

 

@Sandi241 

If you have cells with links, to extract the latest is only with VBA, please check Can I use an excel formula to extract the link location of a hyperlink in a cell? - Super User