Copilot in Excel Issues

How to Add Email Addresses with Copilot in Excel

Anum MushtaqAnum Mushtaq Nov 11, 2026 870 views

Question details

The user needs to generate an Email column automatically by combining existing first and last name columns using Microsoft Copilot in Excel.

How to Add Email Addresses with 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.
Before you start

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.

Solution 1Recommended

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.

1
Open Copilot in Excel

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.

2
Enter the Prompt

In the chat box, type a prompt requesting the new column, such as: 'Add an email column using the format Firstname.lastname@wingtiptoys.com'.

3
Review the Suggested Formula

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.

4
Insert the Columns

Hover over the formula preview generated by Copilot and click the 'Insert Columns' button to apply the calculated email addresses to your Excel Table.

Using Copilot to Generate the Email Formula
Feature Availability: Copilot feature availability may vary based on your Microsoft 365 account type, licensing, and rollout status.
Automate Data Entry with WPS Spreadsheet

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. 1. Open your data in WPS Spreadsheet: Launch WPS Office and open your .xlsx file containing the first and last name columns.
  2. 2. Create an Email Column: Add a new column header named 'Email' next to your name columns.
  3. 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. 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.
Seamlessly open, edit, and save Microsoft Excel (.xlsx, .csv) files without formatting loss.Utilize built-in text formulas like LOWER and CONCATENATE to automate email generation easily.Completely free and lightweight, ensuring smooth performance even on older devices.Features a familiar, user-friendly tabbed interface for a zero-learning-curve transition.
microsoft office alternative - wps office

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.