Signature (Visual Basic / VBA)
Public Function RotateWordsLeft( _
ByVal vValue As Variant _
) As Variant
Code Example
RotateWordsLeft("111 222 333") = "222 333 111"
RotateWordsLeft("This is a test.") = "is a test. This"
RotateWordsLeft("This is a test.") = " is a test. This"
RotateWordsLeft(" is a test. This") = "is a test. This " ' 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. |