The purpose of the following example of Excel VBA macro is to get the acronym or an abbreviation of each of the first letter of any given words.
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
Using Split function and space as delimiter, we create an array of word. Then using simple for … to loop, we do looping of each word and take the first letter of each word in array using Left function.
By using iteration and array like this, we will get the acronym of the word in question.
We can directly use the function in Excel formula bar with a reference to the cell that contains the collection of words we want to make an acronym from it as input.

For the details information of each function in use, Split/Ucase/Left, select each function and push F1 while in the Visual Basic Editor.
Pingback: My Blog
Pingback: carpet cleaning in boston
Pingback: springhills hotel
Pingback: wisdom teeth extraction
Pingback: payday advances
Pingback: open in a new browser window
Pingback: visit same day loans
Pingback: www.easyloanfast.com
Pingback: criminal attorneys
Pingback: Man And A Van London
Pingback: accident lawyers car
Pingback: sacoche homme lacoste
Pingback: rent right property management software
Pingback: remove key scratches from car pricing
Pingback: hcg reviews
Pingback: poker stars chips
Pingback: the link
Pingback: bowmel chrysler review
Pingback: bad credit mobile phones
Pingback: learning to draw dvd
Pingback: rimadyl caplets
Pingback: online quotes
Pingback: Extra resources
Pingback: good web design
Pingback: lecterns
Pingback: ice cream makers reviews
Pingback: follow us on twitter
Pingback: pre construction
Pingback: Creation Site Internet Annecy
Pingback: How to Tie a Tie
Pingback: natural health
Pingback: scrapeboxlist
Pingback: Juegos de furbol
Pingback: jewelry buyer
Pingback: pastry chefs
Pingback: Digital Cameras
Pingback: Software
Pingback: mexican style home
Pingback: Immobilier Concarneau
Pingback: open in a new browser
Pingback: "Saponin
Pingback: freshrankings.com online
Pingback: link
Pingback: casque bluetooth
Pingback: website
Pingback: luxury homes perth
Pingback: event planning template
Pingback: promoting and celebrating Virginia creativity
Pingback: cumming tree service