RTrim, RTrim$ Functions |
Named Arguments
No
Syntax
RTrim(stringexp)
stringexp
Use: Required
Data Type: String
A valid string expression.
Return Value
RTrim returns a variant of subtype String; RTrim$ returns a string.
Description
Remove any trailing spaces from stringexp.
Rules at a Glance
If stringexp contains a Null, RTrim returns Null.
RTrim returns a variant of subtype String.
RTrim$ returns a String data type.
Programming Tips and Gotchas
Unless you need to keep leading spaces, you should use the Trim function, which is the equivalent of RTrim(LTrim(string)), thereby clearing both leading and trailing spaces in a single function call.
See Also
- LTrim Function, Trim Function
Get VB & VBA in a Nutshell: The Language now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.