Excel's TRIM function has a unique way to handle trimming unlike other programming languages / applications. It not only trims the leading and trailing blanks (spaces) but also all blanks in between other than single blank between two words. Official Excel documentation for TRIM says – "Removes all spaces from text except for single spaces between words."
Hence, if you have a string like " I like to add sugar to my drink ", then Excel's TRIM will make it to "I like to add sugar to my drink" whereas other programming languages make it "I like to add sugar to my drink".
Power Query TEXT.TRIM function will just remove leading and trailing spaces like other programming languages/applications.
Below formula can be used to mimic Excel's TRIM function
= Text.Combine(List.RemoveItems(Text.Split([Data]," "),{""})," ")
You have noted very interesting details! ps decent internet site.
Hello, i think that i saw you visited my website so i came to “return the favor”.I am trying to find things to enhance my website!I suppose its ok to use a few of your ideas!!