Text.Split Function in Power Query

The Text.Split function returns a list containing parts of a text value that are delimited by a separator text value, which is given in the function itself.

Syntax

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

Example: Create a list after splitting the given text with delimiter “ ”.

Power Query M

let
  source = "Ashish Goel", 
  return = Text.Split(source, " ")
in
  return

The output of the above code is shown below:

Previous Next