RTrim

Strips any trailing spaces from Str variable.

Syntax

RTrim(Str)

Str:

A string or expression that can represent a valid text value.

Return Value

Returns a String.

Related Functions

LTrim | Trim

Example

Dim strTest as String
Dim strResult as String
Dim lngStartLength as Long
Dim lngFinishLength as Long
strTest = "VBA "
lngStartLength = Len(strTest) ' returns 9
strResult = RTrim(strTest) ' returns "VBA"
lngStringLength = Len(strResult) ' returns 3