Be the first user to complete this post
|
Add to List |
VBA-Excel: String Functions – RTrim()
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()
Also Read:
- VBA-Excel : Strings Functions – Ucase
- VBA-Excel: String Functions – Space()
- VBA-Excel: Array Functions – Filter()
- VBA-Excel: String Functions – Trim()
- VBA Excel – Refer to Multiple Ranges : Union Method