How to use the RTRIM Function (VBA)
Description
The Microsoft Excel RTRIM function removes trailing spaces from a string.The RTRIM function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a VBA function (VBA) in Excel. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.
Syntax
The syntax for the RTRIM function in Microsoft Excel is:RTrim( text )
Parameters or Arguments
- text
- The string that you wish to remove trailing spaces from.
Returns
The RTRIM function returns a string value.Applies To
- Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Function
- VBA function (VBA)
Example (as VBA Function)
RTrim("Tech on the Net ")
Result: "Tech on the Net"
RTrim(" Alphabet ")
Result: " Alphabet"
Dim LResult As String
LResult = RTrim(" Alphabet ")
ليست هناك تعليقات:
إرسال تعليق