Feb 17 2021 02:15 PM
Feb 18 2021 01:41 AM
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:
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.
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.
Feb 18 2021 02:36 AM
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