From the course: Excel: Managing and Analyzing Data
Join today to access over 24,400 courses taught by industry experts.
Splitting columns with Power Query - Microsoft Excel Tutorial
From the course: Excel: Managing and Analyzing Data
Splitting columns with Power Query
- [Narrator] A lot of times, we have to split data apart. In this situation, in column B, we have names and emails that are all in the same cell. And look at the first one. We have Paul Maddocks, PhD, and then Paul's email address, PHDPaul@99MothLabs.org. Then there's Fayette Sandoval, and the email address Fay@Pizza5988.com. And then over in column C, we would like to split out the double E in the first entry. We want to split out the RT and then the LLL, et cetera on down the column. This is a mess to do in Native Excel, but there is text to columns, but text to columns would create a mess for us. So we're not even going to look at that right now. We're going straight into Power Query. The cursor is in the data set. I'm going to right click, get data from table slash range. Okay. Here is how we can split out the email addresses first. The column is highlighted, split column. Now look at all of these options that we have, by delimiter, by positions, by digit to non digit. All of…
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.
