Whenever you enter an email address in a worksheet, then Excel automatically turns the email address into a link. If you are looking for a way to remove this link, then this article will be beneficial to you. The focus of this article is to explain how to remove email link in Excel.
Download Practice Workbook
7 Quick Ways to Remove Email Link in Excel
I have taken the following dataset to explain this article. This dataset contains the Employee ID, Employee Name, and Email ID. Here, the email address is inserted as a link. I will show you how to remove email link in Excel in 7 quick ways.
1. Using Edit Hyperlink Option to Remove Email Link in Excel
In this method, I will use the Edit Hyperlink dialog box to remove email link in Excel. Let’s see the steps.
Steps:
- Firstly, Right-click on the cell where you want to remove the email link.
- Secondly, select Edit Hyperlink.
After that, a dialog box named Edit Hyperlink will appear.
- Next, select Remove Link.
Now, you will see that the email link is removed from the email address and you have got the email address as text.
- After that, remove email links from other email addresses in the same way.
Read More: How to Remove Hyperlink from Excel (7 Methods)
2. Applying Remove Hyperlink Feature
Here, I will explain how to remove email link in Excel by applying the Remove Hyperlink feature. In this method, you will be able to remove email links from multiple cells at the same time. Let me show you the steps.
Steps:
- Firstly, select the cells where you want to remove the email links.
- Secondly, Right-click on the selected cells.
- Thirdly, select Remove Hyperlinks.
Finally, you will see the links have been removed from the Email ID.
Read More: How to Remove All Hyperlinks in Excel (5 Methods)
3. Use of Clear Command to Remove Email Link in Excel
In this method, I will show you how you can use the Clear command in Excel to remove email links. Here, you can remove the links without changing the format.
Let’s see the steps.
Steps:
- Firstly, select the cells from where you want to remove the email links.
- Secondly, go to the Home tab.
- Thirdly, select Clear.
Here, a drop-down menu will appear.
- After that, select Clear Hyperlinks.
Now, the links will be removed but the format will not change.
- After that, click on the Clear Hyperlinks Options.
- Next, select Clear Hyperlinks and Formats.
Finally, you will get your desired output.
Read More: [Solved]: Remove Hyperlink Not Showing in Excel (2 Solutions)
4. Employing Find and Replace Feature to Remove Email Link in Excel
Here, I will explain how you to remove email link in Excel by employing the Find and Replace feature. By using this method you will be able to remove all the links that are in your excel sheets. I will help you to find all the email links.
To explain this method the following dataset. This dataset contains Employee ID, Employee Name, Website they are working on, and Email ID. I will find all the links that are on this excel sheet and remove all the links at the same time.
Let’s see the steps.
Steps:
- Firstly, press CTRL+F on your keyboard to open the Find and Replace dialog box.
- Secondly, select Options.
- Thirdly, click on the drop-down option for Format.
- After that, select Choose Format From Cell.
- Next, select a cell that contains a link. Here, I selected cell D5.
- After that, select Find All to find all the cells that contain links.
Now, you will see that the cells containing links will appear.
- Next, press SHIFT+Down Arrow (↓) on your keyboard to select all the cells.
- Then, close the Find and Replace dialog box.
Here, all the cells that contain links will be selected.
- Firstly, Right-click on a selected cell.
- Secondly, select Remove Hyperlinks.
Finally, the links will be removed.
Read More: How to Remove Hyperlink for Entire Column in Excel (5 Ways)
5. Using Paste Special Option to Remove Email Link in Excel
In this method, I will show you how you can use the Pase Special option to remove email link in Excel. Let’s see how it is done.
Steps:
- Firstly, select any blank cell from the worksheet. Here, I selected cell B11.
- Secondly, copy the cell by pressing CTRL+C on your keyboard. Here, CTRL+C is the keyboard shortcut for the copy option.
- Secondly, select the cells from where you want to remove email links. Here, I selected cell range D5:D9.
- Thirdly, Right-click on the selected cells.
- After that, select Paste Special.
Here, the Paste Special dialog box will appear.
- Firstly, select Add from Operation.
- Secondly, select OK.
Finally, you will see that you have removed the email links in Excel.
Read More: How to Remove Hyperlink Permanently in Excel (4 Ways)
6. Use of Macros to Remove Email Link in Excel
Now, I will show you how you can use Macros to remove email link in Excel. Here, I will write a VBA code that will remove all of the email links from the active workbook. Let’s see the steps.
Steps:
- Firstly, go to the Developer tab.
- Secondly, select Visual Basic.
After that, the Visual Basic editor window will appear.
- Next, select the Insert tab.
- Then, select Module.
Here, a module will open.
- After that, write the following code in that module.
Sub remove_email_links()
ActiveSheet.Hyperlinks.Delete
End Sub
Code Breakdown
- Here, I created a Sub Procedure named remove_email_links.
- Next, I used the ActiveSheet property so that the macros work on the opened worksheet of the active workbook.
- Then, I used the Hyperlinks.Delete method to remove links from the active worksheet.
- After that, I ended the Sub Procedure.
Now, Save the code and go back to the worksheet.
- Firstly, go to the Developer tab.
- Secondly, select Macros.
Here, a dialog box named Macro will appear.
- Firstly, select remove_email_links from the Macro name.
- Secondly, select Run.
Finally, you will see that you have removed email links in Excel using Macros.
7. Employing Excel Options to Stop Automatic Email Link
In this method, I will show you how you can stop Excel from entering email links automatically. Here, I have taken the following dataset. I will insert the Email ID into this dataset without turning it into a link.
Let’s see the steps.
Steps:
- Firstly, go to the File tab.
- Secondly, select Options.
After that, a dialog box named Excel Options will appear.
- Firstly, go to the Proofing tab.
- Secondly, select AutoCorrect Options.
Here, the AutoCorrect dialog box will appear.
- Firstly, go to the AutoFormat As You Type tab.
- Secondly, uncheck the Internet and network paths with hyperlinks option.
- Thirdly, select OK.
- After that, select OK from Excel Options.
- Now, simply write the Email ID and it won’t turn into a link. Here, I wrote my first Email ID.
In the following picture, you can see that I have got my desired dataset.
Read More: Remove External Links in Excel
How to Extract Name from Email Address in Excel
In this section, I will explain how to extract name from email address in Excel. Here, I have taken the following dataset. I will extract the Name and the Domain from the Email ID by using the LEFT function, the RIGHT function, and the FIND function.
Let’s see the steps.
Steps:
- Firstly, select the cell where you want to extract the Name. Here, I selected cell E5.
- Secondly, in cell E5 write the following formula.
=LEFT(D5,FIND("@",D5)-1)
Formula Breakdown
- FIND(“@”,D5) —-> Here, the FIND function will return the position of “@” in the text string that is in cell D5.
- Output: 11
- FIND(“@”,D5)-1 —-> turns into
- 11-1 —-> Now, 1 will be subtracted from 11.
- Output: 10
- 11-1 —-> Now, 1 will be subtracted from 11.
- LEFT(D5,FIND(“@”,D5)-1) —-> turns into
- LEFT(D5,10) —-> Here, the LEFT function will return the 10 characters from the left side of the text string in cell D5.
- Output: “Terry22001”
- Finally, press ENTER to get the Name.
- Now, drag the Fill Handle to copy the formula.
In the following picture, you can see that I have copied the formula to the other cells and thus extracted names from the email address.
Now, I will extract the Domain from the Email ID.
- Firstly, select the cell where you want to extract the Domain. Here, I selected cell F5.
- Secondly, in cell F5 write the following formula.
=RIGHT(D5,LEN(D5)-FIND("@",D5))
Formula Breakdown
- FIND(“@”,D5) —-> Here, the FIND function will return the position of “@” in the text string that is in cell D5.
- Output: 11
- LEN(D5) —-> Now, the LEN function will return the number of characters in the text string in cell D5.
- Output: 24
- LEN(D5)-FIND(“@”,D5) —-> turns into
- 24-11 —-> Here, 11 will be subtracted from 24.
- Output: 13
- 24-11 —-> Here, 11 will be subtracted from 24.
- RIGHT(D5,LEN(D5)-FIND(“@”,D5)) —-> turns into
- RIGHT(D5,13) —-> Now, the RIGHT function will return the 13 characters from the right side of the text string in cell D5.
- Output: “exceldemy.com”
- RIGHT(D5,13) —-> Now, the RIGHT function will return the 13 characters from the right side of the text string in cell D5.
- Thirdly, press ENTER to get the Domain.
- After that, drag the Fill Handle to copy the formula.
Finally, you can see that I have copied the formula and got the Domain of every Email ID.
Read More: How to Remove Excel Links from Word Document
Things to Remember
- Whenever working with macros, you must save the Excel file as Excel Macro-Enabled Workbook.
- It should be noted that the first 6 methods are for removing email links and the 7th method is for stopping excel from inserting email links automatically.
Practice Section
Here, I have provided a practice sheet for you to practice how to remove email link in Excel.
Conclusion
To conclude, I tried to cover how to remove email link in Excel in this article. Here, I explained 7 quick ways of doing it. I hope this article was helpful for you. For more articles like this visit ExcelDemy. Lastly, if you have any questions feel free to let me know in the comment section below.