← Back to Text functions

Text.TrimEnd

Eliminates any specified characters from the end of the original text value using trimChars.

Syntax

Text.TrimEnd(text as nullable text, optional trim as any) as nullable text

About

Eliminates any specified characters from the end of the original text value using trimChars.

Explanation

Eliminate spaces at the end of " a b c d ". Method Power Query MText.TrimEnd("     a b c d    "). Result "     a b c d"