Eliminates any instances of the specified characters in trimChars from the beginning of the original text value.
Syntax
Text.TrimStart(text as nullable text, optional trim as any) as nullable text
About
Eliminates any instances of the specified characters in trimChars from the beginning of the original text value.
Explanation
Eliminate the extra empty space at the beginning of the text " a b c d ". Utilize the Power Query function MText.TrimStart(" a b c d ") to achieve the desired output: "a b c d ".