Data Separation from one cell to two

I don't know if the title explains it, but I was given an Excel Directory type file (name, address, telephone etc.) which has been giving me issues with various exports because of how it's formatted.

Specifically there is one names column with "Last Name, First Name" and then a "City, State Zip" column. I'm hoping that there is a way I can separate the "Name" column by extracting just the last names and copying them to a new column. Likewise I would like to be able to extract City, State and Zip and put them each in their own columns. Is this even possible to do?