Write a VBA Function to parse a String by aziyo

Write a VBA function that takes in String and returns an array, i.e.: In: ” AMER EXP CDA CORP 4.70 20MAY11″ Out: “(AMER EXP CDA CORP,4.70,20,MAY,11) Not all are this straightforward. See attachment for a list of sample inputs and expected outputs… (Budget: $30-$250 USD, Jobs: Excel, PHP, Software Architecture, Visual Basic)