Adding email addresses using Copilot in Excel

Greetings, this is the second in a series of posts that provides examples of what is possible with Copilot in Excel.  Today I will continue with the list of employees from yesterday.

 

Table with these columns: Name Address City State. First two rows of data are: Claude Paulet 123 Main Avenue Bellevue Washington Claude Paulet Jatindra Sanyal 1122 First Place Ln N Corona California Jatindra Sanyal

I would like to add an email address column to this table. For this company, Wing Tip Toys (fictitious), Email addresses have a period between the first and last name and the domain is Wingtiptoys.com. To accomplish this, I'll start by clicking on the copilot button on the right side of the Home tab, showing the copilot pane and type the prompt:

 

 Add an email column where email is in the form Firstname.lastname@wingtiptoys.com

 

Copilot in Excel looks at the content in the table and then suggests inserting a column that adds a calculated column with a formula that concatenates everything together.

 

Looking at A1:F17, here's 1 formula column to review and insert in Column G: Email Generates a professional email address for each individual by combining their first and last names in lowercase, separated by a period, and appending "@wingtiptoys.com". =LOWER([@[First name]]&"."&[@[Last name]]&"@wingtiptoys.com")

 

Hovering the mouse cursor over the "Insert columns" button in the copilot pane shows a preview of what inserting the new column formulas will look like.  From the preview, it looks like it is doing what I wanted.

 

Picture of the list of employees with a preview of the new email column that would be added with the concatenated email addresses in each row.

Clicking on the Insert Columns button will accept the proposed change, inserting a new calculated column formula that concatenates the first and last names with a period in between and appends the company domain at the end, giving me the result I was looking for!

 

Picture showing the Excel workbook with copilot pane open. Includes the employee table with one new email column added.

Over the coming weeks I will be sharing more examples of what you can do with Copilot in Excel.

 

Thanks for reading,

Microsoft Excel Team

 

*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.