Function String Words Class

AcronymFromCapitals

Extract all of the capital letters from a string.

Signature (Visual Basic / VBA)

Public Function AcronymFromCapitals( _
    ByVal vPhrase As Variant _
    ) As Variant

Code Example

    AcronymFromCapitals("Hello Joe") = "HJ"
    AcronymFromCapitals("This is a test.") = "T"

Parameters

Parameter Description
vPhrase String containing the words whose capital letters will be returned. Function returns Null if vPhrase 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.