Function Acronym(Words As Variant) As String
Dim aWord() As String, ix As Integer
aWord = Split(Words.Value, " ")
For ix = 0 To UBound(aWord)
Acronym = Acronym & UCase(Left(aWord(ix), 1))
Next ix
End Function
Dim aWord() As String, ix As Integer
aWord = Split(Words.Value, " ")
For ix = 0 To UBound(aWord)
Acronym = Acronym & UCase(Left(aWord(ix), 1))
Next ix
End Function
No comments:
Post a Comment