VBA – Last Word
In class, we wrote a formula that returns the first word in a string. For example, if a string is “1600 Pennsylvania Avenue”, the formula returns: 1600. Write a similar function in VBA to return the last word. Add both of these formulas to your function add in.
Read the Bogle article. (sorry for the confusion on this)