From the course: Microsoft Copilot for Excel
Join today to access over 25,200 courses taught by industry experts.
Working with text
From the course: Microsoft Copilot for Excel
Working with text
- [Instructor] All right, in the next few demos, I want to continue to showcase Copilot's ability to write formulas in different common Excel scenarios. And I want to start with text functions. So right here you'll see that we have an email for each employee, all of which end with @acme.com. So maybe we want to create a new column that only contains the username for each employee. So let's see if Copilot can help with that. Let's write our prompt. So we want to extract the username from the email column, straightforward enough, and let's wait for Copilot to work its magic. Now you'll see that even for a simple prompt like this, it does take its time, but here we go. Looks like we have a formula back, and it looks to be using the new TEXTBEFORE function, which, as its name implies, grabs the text before the at sign in the email field. And I actually think this is pretty ironic, because in the past, when TEXTBEFORE didn't exist, Copilot would've been a great tool for writing a…
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.