← Back to Text functions

Text.Split

This function generates a list of text values by breaking down a given text value according to a specific delimiter or separator.

Syntax

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

About

This function generates a list of text values by breaking down a given text value according to a specific delimiter or separator.

Explanation

To generate a list from the text value "Name|Address|PhoneNumber", delimited by "|", utilize Power Query MText.Split function. This will result in the output of {"Name", "Address", "PhoneNumber"}.