# How to Add Email Address to List of Names in Excel

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.