How to Add the Same Email Address to a List of Names in Excel?

An email address of a person, in most cases, is generally a combination of the first and last name, ending with the host details such as @gmail.com, @yahoo.com, etc. Suppose we have an Excel sheet with two columns containing the first and last names of employees, then we can easily append their email addresses in a third column, by combining the data values of the first two columns.

Adding Email Address to a List of Names

We can follow a simple process to add email addresses to a list of names. Basically, this process contains two parts, the first step is to concatenate the first and last names and the second step is to add @gmail.com to every text.

Step 1

Open an Excel sheet and insert the first and last names of a set of employees in the first two columns. Next, select the cell next to the second column and insert the formula CONCAT(A2, B2) in the formula box, which will combine the first two names to create the full name.

Press the "Enter" button to get the first result.

Step 2

Now that you got the first result, all that you need to do next is to drag down the cell from its right corner to get all the results.

Step 3

After concatenating the first and last names, you need to add @gmail.com at the end of the full name to get the email address of the first person. For that, use the formula =C2&"@gmail.com"

Press the "Enter" button to get the first result.

Step 4

Now drag down from the right corner of the first result to get the final output.

Conclusion

In this tutorial, we used a simple example to demonstrate how you can add email addresses to a list of names in Excel.