Extracting Text and Numbers

I have a spreadsheet that includes something like, "Beverly Hills 90210", what's the easiest way to separate the one field into two fields (city and zip)? I've attempted Text to Columns, separating by space, but because the city names are not consistent, it isn't very simple. But I can separate the zip by using the =RIGHT formula, having trouble with the city.