Public Function AddSpaceBeforeAllCapitals( _
ByVal vValue As Variant _
) As Variant AddSpaceBeforeAllCapitals("CBACorp") = "C B A Corp"
AddSpaceBeforeAllCapitals("AnnoDomini") = "Anno Domini"See also: AddSpaceBeforeCapitals FunctionvValue: 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.
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.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.