Have you ever needed to extract the email name from a list of email addresses in Excel? It can be a tedious task if you have thousands of entries, but with the use of the LEFT and FIND functions, it can be done quickly and easily.
In this tutorial, we will walk you through the steps of how to extract the email name from an email address in Excel.
- Start by selecting the cell that contains the email address you want to extract the name.
- Type “=LEFT(“ and then select the cell again.
- Add a comma, and type in the number of characters you want to exclude from the email address.
In this example, we want to exclude everything after the @ symbol, so we will type “FIND(“@”, C2)” (C2 is the cell that contains the email address). Make sure to close the formula with a parenthesis. - Now press enter. The email name should now be displayed in the cell. You will see the @ with the name. To get rid of it, just add -1 after the formula and press Enter, as we do in the screenshot.
- That’s it! If you want to extract the email name for multiple cells, simply drag the cell with the formula down to the rest of the cells you want to apply it to.
Conclusion
Using the LEFT and FIND functions makes it easy to extract the email name from an email address in Excel. By following these simple steps we discussed above, you can save time and effort in extracting this information from an extensive list of email addresses. Go ahead and try it out!
