Text.Split

Text

Splits a text value into a list of text values using a specified separator.

Syntax

Text.Split(text as text, separator as text) as list

Parameters

Name	Type	Required	Description
`text`	`text`	Yes	The text value to split.
`separator`	`text`	Yes	The delimiter text to split on.

Return Value

list — A list of text values produced by splitting the input text at each occurrence of the separator.

Remarks

Text.Split divides a text value at every occurrence of the separator, returning a list. This is useful for extracting parts of structured text — for example, splitting a full name into first and last names, or splitting a delimited string into individual values.

For more advanced splitting (e.g., splitting by any of several delimiters, or by character transitions), use the Splitter functions.

Examples

Example 1: Split full names into first and last

Table.AddColumn(
    Table.AddColumn(
        Table.SelectColumns(Table.FirstN(Employees, 3), {"FullName"}),
        "FirstName", each Text.Proper(Text.Split([FullName], " "){0}), type text
    ),
    "LastName", each Text.Proper(Text.Split([FullName], " "){1}), type text
)

Result

	FullName	FirstName	LastName
1	alice smith	Alice	Smith
2	BOB JONES	Bob	Jones
3	Charlie Brown	Charlie	Brown

Compatibility

✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks