Filter by Categories
Select all
Business Statements
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Invoice/ Bill
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
Filter by File Types

How to split columns in Power Query Editor ?

How to split column in Power Query Editor

In this blogpost we will learn about splitting columns in Power Query Editor while working in Microsoft Excel.

Introduction to Power Query

Power Query is a data transforming engine which you can use to get data from multiple sources, clean and transform that data and then use it further in the analysis.

Split Columns in Power Query

Just like the text to column option, you have “Split Column” in power query. Let me tell you how it works.

  • Select the column and go to the Home Tab ➜ Transform ➜ Split Column ➜ By Delimiter.

  • Select the custom from the drop-down and enter “-” into it.
  • Now, here you have three different options to split a column.
    • Left-most Delimiter
    • Right-most Delimiter
    • Each occurrence of the delimiter

If you have only one delimiter in a cell, all three will work in the same way, but if you have more than one delimiter then you have to choose accordingly.

Other Examples of Power Query tool in MS Excel 

Below is the list of examples of using Power Query tool in MS Excel, you can learn and master each examples –


Macro Codes in Excel

Learn Excel Quickly
Get full list of Excel Macro Codes