Kicking off a new weekly series that aims to explore new ways in which Copilot in Excel can help empower and inspire the way you work. 

This week, the focus is on how Copilot can create calculated column formulas to improve your tables. The posts highlight formulas that can split full names, concatenate values to create email addresses, work with date columns, convert text to numbers, and show additional units of measure.

Here is an example from Monday, of how Copilot can help split existing columns into multiple columns using a single prompt:
Use Copilot to create new columns given a text prompt

Monday, 12-Aug – Using Excel Copilot to split columns 

Split an existing column into multiple columns.

Tuesday, 13-Aug – Adding email addresses using Excel Copilot

Insert a new column based off an example prompt.

Wednesday, 14-Aug – Working with date columns using Excel Copilot

Add a new column where Copilot uses dates to insert a new data column.

Thursday, 15-Aug – Converting text to numbers with Excel Copilot

Copilot is able to convert a text column to a number format column.

Friday, 16-Aug – Using Excel Copilot to show additional units of measure

Select specified data to create a new column.

These posts will be pinned within the Tech Community Forum, where you can follow along. Here is the pinned post from the week of August 12th – 16th.

​Microsoft Tech Community – Latest Blogs –Read More