Copilot in Excel: Advanced Text Splitting in Excel

Copilot in Excel now handles advanced text splitting and data manipulation. Specifically, we'll split text in column B, which includes countries after a comma, except for USA states. I'll show you how to use Copilot to add a new column and automatically place 'USA' for states or the respective country name for other entries. This includes employing a nested IF statement with the LET function. Follow along to see how Copilot handles this task efficiently.

Chapters/Bookmarks
00:00 Introduction to Advanced Copilot in Excel
00:19 Setting Up the Exercise
00:49 Using Copilot to Split Text
01:30 Understanding the Results
02:18 Conclusion and Further Learning: Make sure you subscribe to my channel!

Blog Post

The File is directly below the video on the Blog Post page

Introduction to Advanced Copilot Features
Excel's Copilot has evolved significantly with Wave 2, introducing powerful capabilities for advanced text manipulation. This blog post explores how to leverage Copilot for complex text-splitting tasks, specifically focusing on separating location data into distinct columns while handling special cases.

In the image below, Copilot wrote an IF function to add the county after the comma in column B to column C, but if it found two capital letters after the comma, it made the county USA.

Leveraging Copilot for Advanced Text Splitting
Here's how to use Copilot to accomplish this task:
* Select your data range (no need to convert it to a table)
* Open the Copilot task pane from the Home tab
* In the prompt box, enter the following instructions:
"Add a new column that extracts the country from column B. If the text after the comma is a two-letter capital abbreviation, put 'USA'. Otherwise, extract the text after the comma."

#chrismenardtraining #copilot #copilotexcel #microsoftcopilot

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!