Split Text Without Delimiters Using Power Query in Excel
Many Excel users rely on formulas or delimiters to split text, but there is a much faster and cleaner method using Power Query. This tutorial shows how to separate text values without using commas, spaces, or formulas.
Step-by-Step Method
Select the text column you want to split.
Convert the selected range into a table.
Go to the Data tab and choose “From Table/Range”.
The data opens in Power Query Editor.
Use the Split Column option or case-based transformation.
Click Close & Load to return the results to Excel.
This approach avoids complex formulas and works perfectly for structured cleanup tasks, especially in reporting, audits, and data preparation workflows.
Why Use Power Query?
Power Query is designed for repeatable, automated transformations. Once created, the same steps can be refreshed with new data instantly, saving hours of manual work.