i need help separating city’s and zipcodes in excel. EXAMPLE: if there is a city

i need help separating city’s and zipcodes in excel.
EXAMPLE: if there is a city

i need help separating city’s and zipcodes in excel.
EXAMPLE: if there is a city that is 30 minuets from downtown i want it to tell me, and to separtae them by major cities.