Signature (Visual Basic / VBA)
Public Function RotateWordsRight( _
ByVal vValue As Variant _
) As Variant
Code Example
RotateWordsRight("111 222 333") = "333 111 222"
RotateWordsRight("This is a test.") = "test. This is a"
RotateWordsRight("This is a test.") = "test. This is a "
RotateWordsRight("test. This is a ") = " test. This is a" ' Warning!
Parameters
| Parameter | Description |
|---|---|
| vValue | String containing the phrase which is to have its first space-separated word moved to the end of the string. Function returns Null if vValue is Null or cannot be fixed up to a String. |
Notes & Version History
| Note | Function uses the built-in character classification routines to determine which characters represent spaces. |