Text.Trim Function in Power Query
The Text.Trim function removes all leading and trailing whitespace from the text.
Syntax
Text.Trim(text as nullable text, optional trim as any) as nullable text
Example: Remove leading and trailing whitespace from the input text.
Power Query M
= Text.Trim(" Ashish Goel ") The output will be “Ashish Goel”. The output will be shown in the following image.
