From the course: Excel for Marketers (2023)

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Cell extraction for further segmentation

Cell extraction for further segmentation - Microsoft Excel Tutorial

From the course: Excel for Marketers (2023)

Start my 1-month free trial Buy for my team

Cell extraction for further segmentation

“

- [Instructor] Do you want to segment your data but you don't have your data in the right format? Well, cell extraction technique can help you break out your data to better analyze it. Here, we have some internal data. This is the source medium and campaign from our marketing campaigns where we drive people to sign up on the website. And this is some internal data that was recorded. It's actually pretty straightforward because this is delimited by the pipe. You can see this is a pipe character here. We have Google, and then that's the source, and then organic, and they have the pipes in between. Now, we can actually just use Text to Columns, in this case. So I'm just going to copy this. Control + Shift + Down and then Control + C. And then we're going to go up to the top, right-click, and then we're going to paste values just so we're not deleting any of this. And then let's just select that and click Text to Columns. And…

Contents