How to Add Email Addresses with Copilot in Excel
Question details
The user needs to generate an Email column automatically by combining existing first and last name columns using Microsoft Copilot in Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Automating the creation of corporate or standardized email addresses from a list of user names in a spreadsheet.
- Observed behavior
- The user wants a calculated table column that formats the first name, last name, and a domain name into a complete lowercase email address.
Ensure your dataset is formatted as an Excel Table (Ctrl+T) and that your file is saved to OneDrive or SharePoint, as Copilot requires these conditions to function.
Using Copilot to Generate the Email Formula
Prompt Copilot to automatically create a calculated column formula that combines names into formatted lowercase email addresses.
Copilot in Excel can understand natural language prompts and instantly generate complex concatenation formulas to manipulate text data.
Click the Copilot icon located on the Home tab of your Excel ribbon to open the Copilot chat pane on the right side of the window.
In the chat box, type a prompt requesting the new column, such as: 'Add an email column using the format Firstname.lastname@wingtiptoys.com'.
Copilot will analyze your table headers and generate a formula, such as =LOWER([@[First name]]&"."&[@[Last name]]&"@wingtiptoys.com"). Review the formula explanation provided in the chat.
Hover over the formula preview generated by Copilot and click the 'Insert Columns' button to apply the calculated email addresses to your Excel Table.

Creating the Email Column Manually
If Copilot is temporarily unavailable or not enabled on your account, you can manually type the concatenation formula to achieve the exact same result.
Easily Generate Email Addresses in WPS Office
You can quickly generate email addresses from name columns in WPS Spreadsheet using built-in text formulas or intelligent data tools. WPS Office is a powerful, free alternative that supports all major Excel features.
- 1. Open your data in WPS Spreadsheet: Launch WPS Office and open your .xlsx file containing the first and last name columns.
- 2. Create an Email Column: Add a new column header named 'Email' next to your name columns.
- 3. Enter the Text Formula: In the first cell of the new column, input =LOWER(A2&"."&B2&"@company.com") assuming A is the First Name column and B is the Last Name column.
- 4. Apply to All Rows: Press Enter, then double-click the small square fill handle in the bottom-right corner of the cell to copy the formula down the entire column instantly.

Frequently Asked Questions
Why is the Copilot button missing in my Excel?
The Copilot button may be missing if you do not have an active Copilot Pro or Microsoft 365 Copilot license, if your organization's IT admin has not enabled it, or if your Excel file is saved locally rather than to OneDrive or SharePoint.
Can I use different email domains for different users with Copilot?
Yes. If your table has a separate column specifying the domain or company name for each user, you can prompt Copilot to reference that column (e.g., 'Generate emails using Firstname.Lastname@[DomainColumn]').
Does Copilot in Excel work with regular data ranges?
No, Copilot in Excel currently requires your data to be formatted as an official Excel Table to analyze data and insert calculated columns. You can convert a range to a table by selecting your data and pressing Ctrl+T.
How do I handle duplicate names when generating email addresses?
Copilot generates the initial formula strictly based on your text prompt. To handle duplicates (such as appending a number to the second John Smith), you will need to manually adjust the generated formula using functions like COUNTIF, or provide a highly specific prompt asking Copilot to append numbers for duplicate name combinations.




