TrimEnd(text)

Category: Text function

Description

This function trims off all trailing spaces and other non-printing characters (see Remarks) from text. Leading spaces are preserved.

Arguments

ArgumentTypeDescription
textTextAny text value or other value that can be implicitly converted to text if required.

Return value type: Text

Remarks

Besides spaces, it also removes other non-printing, white-space characters such as tabulations, form feeds, etc. The full list of removed white-space characters.

Examples

trimend('Columbia ') //Returns 'Columbia'
trimend('  Columbia  ') //Returns '  Columbia'  (Leading spaces retained)

See also