Text to Column

Hello Everyone. I'm trying to split data into 2 columns.  The original data is made up of cities and states: Notice that some items have a comma and others don't.  Also, the cities states are d...