Formula to Break an Address into it's Parts

Hi,

I'm looking for a formula to break an address into it's parts. There are just a couple variations, and there are comma's after everything item EXCEPT between the US State abbreviation and the ZIP code.

85 Maple Street, P.O. Box 80427, Stoneham, MA 02180

545 Hupp Avenue, Jackson, MI 49203

I would hope to break it into columns that line up the states whether there is a second address line or not. Maybe an IF statement to count the commas, and if there are only two then it does one thing, if there are three it does another?

End result desired:

Address 1 Address 2 City State ZIP
85 Maple Street P.O. Box 80427 Stoneham MA 02180
545 Hupp Avenue Jackson MI 49203

I hope this is clear!

Thanks!

Well, when it posted, it changed the spacing between the words for me, so my "example" isn't formatted correctly.