From the course: Excel: Power Query for Beginners

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Splitting columns

Splitting columns

From the course: Excel: Power Query for Beginners

Start my 1-month free trial Buy for my team

Splitting columns

“

- [Instructor] So often you'll get data where people's first and last names are within one column. This can be problematic if you need to take this data to another mailing program that generates labels or envelopes. So what we need to do in this situation is we need to split this column into two columns, one for the first name and one for the last name. And we're going to do that with Power Query. I've got the 02_03 SalesData.xlsx file open. I also have the Queries & Connections pane open. And if you don't have that open, head on over to the Data tab, and click Queries & Connections. Or if you're using an older version of Excel, click the Show Queries button. But I have it open, so I'm going to go ahead and right-click this query and choose Edit, and we're going to split that column. So I'll select the column I want to split. In this case, it's the contact name column. And I'll choose Split Column by Delimiter. And…

Contents