Excel: RTrim Function (VBA only)

In Excel, the RTrim function removes trailing spaces from a string.

The syntax for the RTrim function is:

RTrim( text )

text is the string that you wish to remove trailing spaces from.

Applies To:

For example:

RTrim("Tech on the Net ") would return "Tech on the Net"

RTrim(" Alphabet ") would return " Alphabet"

VBA Code

The RTrim function can only be used in VBA code. For example:

Dim LResult As String

LResult = RTrim(" Alphabet ")

The variable LResult would now contain the value of " Alphabet".