Signature (Visual Basic / VBA)
Public Function ShiftStringRight( _
ByVal vValue As Variant _
, Optional ByVal vPositions As Variant _
) As Variant
Code Example
ShiftStringRight("123456789", 3) = "123456"
Parameters
| Parameter | Description |
|---|---|
| vValue | The string whose characters are to be shifted to the right. Function returns Null if vValue is Null or cannot be fixed up to a String. |
| vPositions | The number of positions that each character is to be shifted. vPositions defaults to 1 (one) if it is missing or Null or cannot be fixed up to a number. vPositions can be negative in which case the string is shifted to the left. |