Description:
The RTrim function removes spaces on the right side of a string.
Format:
Rtrim (strMainString)
Arguments:
- strMainString
- Mandatory
- Type: String
- String whose right space needs to be trimmed.
Function FnRTrim() Dim strMainString strMainString = " Sumit Jain " MsgBox "Before : '" & strMainString & "' and after right Space is trimmed. After :'" & RTrim(strMainString) & "'" End Function
Also Read About Other String() Functions
INSTR() | InstrREV() | LCase()
Happy Macroing
![]()
Sumit Jain
“The RTrim function removes spaces on the left side of a string.” <– should be right side of the string.
Thanks jason for pointing it out. Corrected it.