From the course: Excel Copilot: Working with Formulas and Functions
Join today to access over 25,500 courses taught by industry experts.
Cleaning and standardizing text data
From the course: Excel Copilot: Working with Formulas and Functions
Cleaning and standardizing text data
- [Instructor] I'm sure you know that handling text can be just as challenging, if not trickier, than dealing with numbers. So let's explore how Copilot can simplify the text cleaning process. For this exercise, we'll use a file called Cleaning Text Data, which contains a table called Customers. It's filled with typical customer details, but they're currently a mess. The most glaring issue is the customer name column. There's a wild mix of capitalization going on. Let's open up Copilot and see if it can help us. So we'll see if we can get the names in the customer name column properly formatted here. And we do have a suggested function that we could use. It is going to take a little bit of cleanup for us to do. And the text proper function, that's actually not one I had heard of before and there might be a reason for that. It looks like there is an error that we're getting, so we'll let Copilot know that and see if we can get some better advice here. Okay, text proper. We are getting…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.