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 Andy.Miller@gmail.com.
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 AndyMiller@gmail.com.
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 AndyMiller2@gmail.com 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”)
We can then click and drag these formulas down to each remaining cell in each column:
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.
Additional Resources
The following tutorials explain how to perform other common operations in Excel:
Excel: How to Extract URL from Hyperlink
Excel: How to Extract Domain from Email Address
Excel: How to Extract Email Address from Text String
