Table of Contents
The ability to quickly and accurately add email addresses to a list of names in Excel is an invaluable skill in the modern workplace. With the increasing reliance on digital communication, the ability to efficiently store and access contact information is essential. This guide will provide an overview of how to use Excel to add email addresses to a list of names, as well as provide helpful tips and tricks for making the process as simple and efficient as possible.
You can use the following formulas to add an email address to a name in Excel:
Formula 1: Add Email Address Using Period to Separate First and Last Name
=CONCAT(A2, ".", B2, "@gmail.com")
If cell A2 contains Andy and cell B2 contains Miller then this formula would return [email protected].
Formula 2: Add Email Address Using Nothing to Separate First and Last Name
=CONCAT(A2, B2, "@gmail.com")
If cell A2 contains Andy and cell B2 contains Miller then this formula would return [email protected].
Formula 3: Add Email Address Using Random Number After First and Last Name
=CONCAT(A2, B2, RANDBETWEEN(1,9),"@gmail.com")
If cell A2 contains Andy and cell B2 contains Miller then this formula would return [email protected] or a similar email address with a random integer between 1 and 9 added to the first and last name.
The following example shows how to use each formula in practice.
Example: How to Add Email Address to List of Names in Excel
Suppose we have the following columns of first and last names in Excel:
Suppose we would like to add an email address to each first and last name.
We can type the following formulas into the following cells to produce various email addresses:
- C2: =CONCAT(A2, “.”, B2, “@gmail.com”)
- D2: =CONCAT(A2, B2, “@gmail.com”)
- E2: =CONCAT(A2, B2, RANDBETWEEN(1,9),”@gmail.com”)
Each of the new columns displays the email address for each name, using the three different formulas that we specified.
Note: Feel free to use a domain name other than “@gmail.com” in your own dataset. We chose this one simply to illustrate how to use the formula.
In conclusion, the three formulas discussed in this article can be used to add an email address to a name in Excel. The formulas use the CONCAT function to combine the first and last name with an email domain, a period to separate the names, or a random integer to create a unique email address. Using these formulas can save time and make creating email addresses from names in Excel much easier.