Moving parts of a sentence to different cells

I have a list of names in excel that say:

John Smith - Florida 2011
John Smith - Florida 2011 - Called in/Quit

All this information is in Column A, (nothing in the other columns) is there a way to make a formula to split this data up so that in one column it reads as follows:
Column:
A- John Smith B- Florida C-2011 D- any data after 2011, names have notes after the year

I want the data to be copied down if possible I have about 100 pages of names and don’t want to do this manually by coping and pasting

I hope this makes sense, thanks for your help.
The two examples are how the data might appear.

Hi Fish,

Would suggest you to use Text -to - column feature of Excel and that too smartly.... spend some time searching and learning on this feature and you will get it achieve desired results.... Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>