Split Text by Delimiter in Power Query M

Notes

Replace " " with your delimiter, and name the resulting columns as needed.

Requirements

• A table with a text column that contains the delimiter.

How to use this snippet

1. In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
2. Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
3. Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

• Extract Text Before / After a DelimiterSplits a text value at the first occurrence of a delimiter and keeps only the part before or after it.
• Split Full Name into First and Last NameSplits a single Full Name column into separate First Name and Last Name columns at the first space.
• Extract Text Between DelimitersPulls out the text found between two delimiters, such as text inside parentheses.
• Remove Extra Spaces Between WordsCollapses repeated spaces inside a text value down to a single space, in addition to trimming the ends.
• Extract Digits Only from TextRemoves every non-numeric character from a text column, leaving only the digits.
• Email Format Validation FlagAdds a boolean column flagging whether a text value looks like a valid email address.

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Split Text by Delimiter.