VBA RTrim function

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)

LTrim Function Description

The VBA RTrim function removes trailing whitespaces from a string, looking from the right side of the string.

To remove leading whitespaces see LTrim, to remove both trailing and leading whitespaces see Trim.


The syntax for the RTrim function in VBA is:

RTrim( text )


The string for which you wish to remove any trailing (looking from the right) whitespaces from.

Other Notes

RTrim does not remove non-whitespace characters such as new lines (vbNewLine, vbCrLf) etc.

Example usage

The RTrim function can be used in VBA code. Let’s look at some VBA RTrim function examples:

RTrim "Hello world!   "
'Result: "Hello world!"

RTrim "   Hello world!   "
'Result: "   Hello world!"

RTrim " Some Text " & vbNewLine & "   "
'Result: " Some Text " & vbNewLine 

Simply the best place to learn Excel VBA