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. 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. , 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. 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.Using Copilot in Excel to split columns
Hi Everyone, this is the first in a series of posts to show you some of the things that are possible to do with your workbooks using Copilot. Today I will start with this list of employees: I would like to have the names in this list separated into 2 columns for the first and last names. 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: Split the name column into first and last name Copilot in Excel looks at the content in the list and then suggests inserting 2 new calculated column formulas to split the first and last names from the Name column. formula columns to review and insert in Columns E and F: 1. First name Extracts the first name of each individual by splitting the full name at the space and selecting the first part. =INDEX(TEXTSPLIT([@Name]," ",,TRUE),1,1) Show explanation 2. Last name Extracts the last name of each individual by splitting their full name and selecting the last part. =INDEX(CHOOSECOLS(TEXTSPLIT([@Name]," ",,TRUE),-1),1,1) 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 2 new columns with calculated column formulas that split out the first and last names, 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.
Chat with Copilot popup on every Excel launch
An ad for Copilot shows up every single time I open Excel. Clicking Not Now closes it, only for it to reopen again when I open Excel later. Is there any way to disable this or remember my selection each time? It is frustrating to have to deal with it all day long. I do not have a Copilot tab in File > Options. Optional connected experiences is already disabled. Microsoft® Excel® for Microsoft 365 MSO (Version 2511 Build 16.0.19426.20218) 64-bit Windows 11 Pro 25H2
People data lookups
Hi, I have created an MS Form where anyone can nominate their peers for recognition - we have 20k employees. I've added a field in the form for a unique employee number for the nominator to include. So they would submit the nominee's: emp number, full name, role, area of the business. The output comes to me in excel and I need to update a list of 00's of employees, where they work, their contact details, line manager detail etc. The challenge is this: whilst I can do all the look-ups to the external data to provide this, the output of the form could have numerous errors. First of all, a missing emp number or incorrect emp no. Second of all, incorrect name spelling, or shortened names, or duplicate names, or too many spaces etc. Then there's incorrect role or missing role, and finally the same for area of the business. Using either multiple IFs or look-ups or Power Query, what's the best solution to pull through the correct emp number (from my external data), when those first four fields could be all wrong, partly wrong, missing or all correct, and what about dealing with duplicate names? I can concatenate if the four fields are correct, but this isn't reliable. Is there a fuzzy match that takes the best guess at the four fields completed - leaving me to just check a handful of #N/As? I have Copilot and licence too. Thanks!Agent Mode continuously loading
Hi all, I installed Excel Labs today and have tried to use https://www.microsoft.com/en-us/microsoft-365/blog/2025/09/29/vibe-working-introducing-agent-mode-and-office-agent-in-microsoft-365-copilot/ for Excel in the web. However, no matter which prompt I use, it just loads continuously, even when left for hours. Has anyone got this working? Or know how to resolve this? I appreciate it's a Preview feature, so happy to wait if it's a temporary glitch, but thought it'd be worth checking.Quickly transform some data for analysis using Copilot in Excel
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. We have transitioned from daily to weekly and we are posting on the Excel blog (https://aka.ms/xlblog). This week's example shows how to quickly transform this table: Into this: To read how to use Copilot to do this, click here: Quickly transform some data for analysis using Copilot in Excel. Microsoft Excel TeamGetting help from Copilot in Excel creating a formula to calculate distinct values
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. This week I have a table of event locations, and I’d like to figure out a formula to count up the distinct locations. I would like to find out how many locations are listed, so I ask Copilot: How many distinct locations are there? I analyzed data in B2:C156, and here's what I found: Distinct Count of Location 50 Copilot said: There are 50 distinct locations. Copilot returns an answer of 50, but I would like to have a formula that updates as the list changes. A coworker suggested the formula below, but I don’t understand it. I ask copilot: A coworker gave me this formula to calculate the distinct locations, can you tell me how it works: =SUM(--(FREQUENCY(MATCH(C:C, C:C, 0), MATCH(C:C, C:C, 0)) > 0)) This formula calculates the number of distinct locations in column C. Here's how it works: MATCH(C:C, C:C, 0): This part of the formula creates an array of the positions of each value in column C. The 0 indicates an exact match. FREQUENCY(MATCH(C:C, C:C, 0), MATCH(C:C, C:C, 0)): The FREQUENCY function is used to count the number of times each value appears in the array created by the MATCH function. It returns an array where each element represents the frequency of the corresponding value. FREQUENCY(...) > 0: This part of the formula creates a boolean array where each element is TRUE if the corresponding frequency is greater than 0, and FALSE otherwise. --(FREQUENCY(...) > 0): The double unary operator (--) converts the boolean array into an array of 1s and 0s, where TRUE becomes 1 and FALSE becomes 0. SUM(...): Finally, the SUM function adds up the array of 1s and 0s, giving the total count of distinct locations. I understand the formula, but it seems overly complicated. I’d like to see if Copilot can do better. I ask: Can you simplify the formula? Yes, I can simplify the formula. Here is a more straightforward way to count distinct locations using the UNIQUE and COUNTA functions: =COUNTA(UNIQUE(Table19[Location])) That is much simpler! I copy the formula from the copilot pane and copy into my workbook. Now when I make changes to the table, the unique location count updates automatically. Here are some additional examples from the last six weeks if you missed them: Copilot in Excel examples for the week of August 12th Copilot in Excel examples for the week of August 19th Copilot in Excel examples for the week of August 26th Copilot in Excel examples for the week of September 3rd Copilot in Excel examples for the week of September 9th Copilot in Excel examples for the week of September 16th Stay tuned, 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.Copilot in Excel riddles
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. Today we’re going to try something fun: tell me a riddle about an Excel feature Sure! Here’s a riddle for you: I can sum, I can average, I can count with ease, I can find the max and min, if you please. I live in a cell, but I’m not in jail, What am I? Can you unveil? What Excel feature am I? What is the answer? The answer to the riddle is a formula! 😊 Formulas in Excel can sum, average, count, find the maximum and minimum values, and perform many other calculations within a cell. Give me a riddle where the answer is conditional formatting Sure! Here's a riddle for you: I change colors based on rules, Highlighting cells, making them cool. With red, green, and yellow hues, What Excel feature am I, can you deduce? What am I? 😊 Maybe try with your friends or coworkers and test their Excel knowledge in a fun way. Over the coming weeks I will continue to share 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.
