Excel Formulas to Create Email Address with Name and Domain!!
Tags: excelformula, excelformulas
Published: 2021-07-03 03:33:12

---
title: Excel Formulas to Create Email Address with Name and Domain!!
published: true
date: 2021-06-28 11:13:39 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-create-email-address-with-name-and-domain/
---

When you have some contacts’ first names in a column, and the last names in another column, now, you want to create email addresses for each of them by combining their first and last names as the usernames and use the same email domain, such as google.com. How can you create the email addresses quickly? Today I will introduce some quick tricks to **create an email address with a name and domain in Excel**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Create email address with name and domain](https://geekexcel.com/wp-content/uploads/2021/06/Create-email-address-with-name-and-domain.png)](https://geekexcel.com/excel-formulas-to-create-email-address-with-name-and-domain/create-email-address-with-name-and-domain/#main)<figcaption id="caption-attachment-48065">Create an email address with name and domain</figcaption>

## Generic Formula:

- You can use the below formula to create an email address with name and domain in Excel.

**=[LOWER](https://geekexcel.com/how-to-use-lower-function-in-microsoft-excel-365/)([LEFT](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/)(first)&last&”@”&domain)**

## Syntax Explanations:

- **LOWER** – In Excel, the [**LOWER function**](https://geekexcel.com/how-to-use-lower-function-in-microsoft-excel-365/) helps to return a lower-case version of a given text string.
- **LEFT** – The **[LEFT Function](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/)** will extract the first character (starting from the left side) or characters from the given string based on the number you specified.
- **First Name** – It represents the first name.
- **Last Name** – It specifies the last name.
- **Domain** – It specifies the domain name.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- Here, we will enter the input values in **Column B** and **Column C**.
- Now we are going to build an email address from a first and last name.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-79.png)<figcaption id="caption-attachment-48067">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-94.png)<figcaption id="caption-attachment-48066">Enter the formula</figcaption>

- Finally, press the ** ENTER**  key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result-79.png)<figcaption id="caption-attachment-48068">Result</figcaption>

## Wind-Up:

From this chapter, you can get to know how to **create an email address from a first and last name in Excel**. If you have any **issues** regarding this article or any unresolved **queries** , please comment in the **comment** box below. We will assist you.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Calculate Total Income Tax with Multiple Tax Brackets!!](https://geekexcel.com/excel-formulas-to-calculate-total-income-tax-with-multiple-tax-brackets/)**
- **[How to Insert a Date or Formatted Date in Excel Office 365?](https://geekexcel.com/how-to-insert-a-date-or-formatted-date-in-excel-office-365/)**
- **[Excel Formulas to Calculate the Surface Area of a Sphere ~ Quickly!!](https://geekexcel.com/excel-formulas-to-calculate-the-surface-area-of-a-sphere/)**
- **[Excel Formulas to Calculate the Distance in 2D ~ Quick Solutions!!](https://geekexcel.com/excel-formulas-to-calculate-the-distance-in-2d/)**