Function String Words Class

AddSpaceBeforeAllCapitals

Adds a space character before all capital letters in string vValue. Function does not add a space before the first character of the string if it is a capital letter.

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.