Text.ToList Function in Power Query

The Text.ToList function returns a list of characters from the given text value.

Syntax

Example: Create a list of character values from the text "Ashish Goel".

Power Query M

let
    Source = Text.ToList("Ashish Goel")
in
    Source

The output of the above formula is shown below:

Output

{
    "A",
    "s",
    "h",
    "i",
    "s",
    "h",
    " ",
    "G",
    "o",
    "e",
    "l"
}