How to add the same email address to a list of names in Excel?
In many office environments, organizing contact lists is a routine but critical task. You might have a spreadsheet containing contacts’ first names in one column and last names in another, and your goal is to quickly generate email addresses for each person by combining their names as the username and appending the same domain—such as google.com—to create standardized company or group emails. Rather than manually entering each address, using Excel’s built-in tools or add-ins can save significant time and reduce errors. This tutorial provides step-by-step guidance on efficient ways to generate these email addresses, whether you prefer formulas or advanced tools like Kutools for Excel.
For example, if your Excel sheet looks like this:
Add the same email address to names with a formula in Excel
Add the same email address to names with Kutools for Excel
Add the same email address to names with a formula in Excel
Suppose you have first names in column A and last names in column B. To quickly generate a standardized email address for each contact by combining their names and appending the same domain, you can use a simple Excel formula. This method is widely applicable, especially for small to moderate-sized lists, and is compatible with all modern Excel versions.
Here’s how to set it up efficiently:
1. Click cell C1, which will be the column for your new email addresses. Enter the following formula:
=CONCATENATE(A1,".",B1,"@google.com")Alternatively, in recent versions of Excel, you can use TEXTJOIN or the & operator for similar results. Here’s an equivalent formula using &:
=A1 & "." & B1 & "@google.com"Both formulas concatenate the first name, a dot, the last name, and then attach the domain. After entering the formula, press Enter.
2. To fill the rest of your list, click cell C1 to select it, hover over the small square (fill handle) in the bottom right corner of the cell, and drag it down the column to apply the formula to other rows. This populates the column, automatically building unique email addresses for each contact.
Tip: If you have hundreds or thousands of names, you can double-click the fill handle to auto-fill down as far as there are entries in the adjacent columns. Make sure that your first and last name columns contain no blank rows within the dataset, as this may interrupt autofill.
Note: You can customize the separator and email domain to suit your organization’s requirements. For instance, to use a space between names and a different domain, type:
=CONCATENATE(A1, " ", B1, "@yahoo.cn")
This flexibility helps adjust the username format or adapt to domain changes.
If you wish to convert the email address into a clickable mailto hyperlink in Excel, enter the following formula in the target cell (e.g., C1):
=HYPERLINK(A1 & B1 & "@google.com")After typing the formula, press Enter and drag the fill handle down as before. The cell contents can now be clicked to open your default email client for a new email message. Here’s how it appears:
Then press Enter and use the fill handle to apply the formula for all required cells. The resulting hyperlinks provide a convenient way for direct email initiation:
Note: In the hyperlink formula above, you can adjust google.com to your preferred domain as needed. If your contacts require additional characters (such as underscores or numbers), incorporate them accordingly within the formula.
Be aware that Excel treats formulas and hyperlinks differently: formulas will show the output as text or clickable links, but if you want to export these to another system, ensure you copy and paste as values to preserve the actual email address and not the formula.
Common issues include typing errors, incorrect cell references, or a mismatch between the number of rows in the first name and last name columns. Double-check that your columns align and that all references point to the correct rows to avoid errors, such as #VALUE! or missing addresses.
Add the same email address to names with Kutools for Excel
If you frequently need to combine columns or create batch email addresses, using Kutools for Excel can make the process even more streamlined, especially for larger datasets or when you want to add additional formatting options. Kutools includes many easy-to-use tools suitable for both beginners and advanced Excel users.
After free installing Kutools for Excel, proceed as follows:
1. Select all the name cells you want to generate email addresses for. Then click Kutools > Merge & Split > Combine Rows, Columns or Cells without Losing Data. See screenshots below for reference:
2. In the dialog that appears, configure the options as follows for optimal results:
(2) Choose Spaces or another separator (such as a period or underscore) under Specify a separator;
(3) Pick the location where you want the results to be placed (e.g., rightmost column);
(4) Select the combination option that matches your desired output format.
Choosing separators and result position allows you to customize the final username format and keep your sheet organized. If you're not sure which separator to choose, preview how the outcome appears by trying different options before clicking Ok.
3. After clicking Ok, the combined full names are generated. Without deselecting these new cells, open Kutools > Text > Add Text. This feature allows bulk addition of your chosen email domain to all selected rows, minimizing manual entry.
4. Within the Add Text dialog box, enter your desired email postfix (such as @google.com) into the Text field and select After last character to ensure the domain is added directly after the username. Review a quick screenshot for guidance:
5. Press Ok. The email addresses are now appended to each contact’s name, producing a complete email address list for your Excel worksheet.
This Kutools method is ideal for long lists or when the email formatting needs to be adjusted in batches. If you need to change the separator or add text at a different position (such as before the names or between them), Kutools provides flexible settings within each dialog. If you notice that the output isn’t as intended, use Undo or rerun the function to modify your choices.
If any errors arise (such as duplicate entries or missing rows), double-check that all relevant cells are selected and that options in the dialogs match your intended output. Kutools’ user interface makes it easier to preview changes before confirming, so take advantage of this to avoid mistakes.
The Kutools workflow is especially useful if you prefer menu-based solutions over formulas, want line-by-line precision, or need advanced batch operations, such as separating first and last names, reordering columns, or inserting additional characters into the usernames.
Other Formula Alternatives and Tips
If you want more control over removing spaces, special characters, or formatting the email addresses, the following formula alternatives may help:Enter this formula in cell C1 (or your target cell):
=LOWER(A1 & "." & B1 & "@google.com")This formula outputs the email address in all lowercase letters, which may be desirable for standardizing addresses and avoiding issues with case sensitivity across email clients.
To remove any leading or trailing spaces from the names before building the email address, use:
=TRIM(A1) & "." & TRIM(B1) & "@google.com"This is especially useful when the data source may contain accidental spaces, ensuring that generated addresses do not have unnecessary whitespace.
After entering one of these formulas, press Enter, then drag the fill handle down to apply to other rows. Always check your results for typos or unintended formatting, especially when importing the list into email systems.
To summarize, whether you use Excel’s built-in formulas, hyperlink options, or Kutools add-ins, you have a range of methods available to speed up and standardize the generation of email addresses for your contact lists. Choose the approach that best fits your volume of data and your preferred working style, and always review the final list for accuracy before sharing or uploading to other systems.
Add Same Email Address To A List Of Names
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in