Split cells

Excel You start by saying "Suppose this is the data". That could mean that your real data isn't like in your screenshots at all. But let's suppose it is, then you could go through a number of Text-to-column steps, manually, or you use Power Query (PQ). The attached file contains a PQ solution.

First split by the comma. This will create three columns:

Then split the first column at the point where a character changes to a number (digit):

Then add a custom column that excludes any number from the field that contains the city:

Trim the custom column, delete the original column with the city information and reorder the remaining columns:

Load the end result back to Excel: