Aug 13 2024 06:54 AM - edited Aug 26 2024 04:11 PM
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.
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.
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.
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!
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.