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.