Be the first user to complete this post
|
Add to List |
VBA-Excel : Strings Functions – Right
Description:
Returns a string containing number of characters specified by the user, starting from right side of the input string.
Format:
Right(strMainString,intLength)
Arguments:
- strMainString
- Mandatory
- Type: String
- String whose characters to be returned.
- intLength
- Mandatory
- Type: Numeric
- Number of characters to be returned.
- If number specified is greater than the string length then entire string is returned.
Function FnRight() Dim mainString mainString = "SumitJain" intLngth = 5 MsgBox "The first " & intLength & " characters from Right are ' " & Right(mainString, intLngth) & " '" End Function
Also Read About Other String() Functions
INSTR() | InstrREV() | LCase()
Also Read:
- VBA-Excel: Date-Time Functions – DateValue()
- VBA-Excel: Array Functions – Filter()
- VBA-Excel: Date-Time Functions – DateDiff()
- VBA-Excel: Arrays – Two Dimension, Dynamic Array
- VBA-Excel: Select and Activate Cells - Select