Move parts of info in a cell into their own cells

I have a list of over 5,000 names and addresses. The problem is that the city,state,zip part are in one cell but I need them to be split into three different columns. Ive attached a small sample of how it is now and how I need it to be. Please help

In C2
=LEFT(A2,FIND("-",A2)-9)

In D2
=MID(A2,FIND("-",A2)-8,2)

in E2
=RIGHT(A2,LEN(A2)-FIND("-",A2)+6)

Then copy down

Hi beezer2484

Not knowing if your Zip code are the same length or if the city has more then 2 words see the attached.