TRIM function of Excel and Text.Trim functions of Power Query both remove leading and trailing spaces (ASCII Char code 32) from a text. But Excel's TRIM goes a step further. If there are mulitiple spaces between words, it will reduce those to a single space between words. Hence if I have a string " Microsoft…
Tag: RTRIM
Excel Trim Formula in Power Query – Tips & Tricks 11
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…
Article 18 – LTRIM and RTRIM through Excel Formulas
So, we have TRIM function in Excel. Almost all programming languages provide LTRIM and RTRIM functions also but Excel doesn't provide LTRIM and RTRIM. The same is provided in VBA but most of the Excel users are not using VBA. They are simple folks who want to accomplish their day to day job through Excel…