Signature (Visual Basic / VBA)
Public Function AddSpaceBeforeAllCapitals( _
ByVal vValue As Variant _
) As Variant
Code Example
AddSpaceBeforeAllCapitals("CBACorp") = "C B A Corp"
AddSpaceBeforeAllCapitals("AnnoDomini") = "Anno Domini"
Parameters
| Parameter | Description |
|---|---|
| vValue | The string which is to have space characters added before all capital letters. 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 are upper-case. |
| Note | Function does not add a space before the initial capital letter if the vValue begins with a capital letter as in example #2. |