I have a field where each months budget is stored separated by a comma.  I have to extract each months budget from the string and show on the report.

I was able to use a combination of the InStr & Left Function to extract the 1^st months budget.  I use a combination of InStrRev & Mid function to retrieve the last months budget.

I need some help in creating a formula to extract months 2 – 11 budget.  Which functions can I use to search the field for the 2^nd, 3^rd, 4^th, 5^th etc. comma extract the number?  will this be handled better by a loop?