I have a column whose cells contain an address and city in each cell. I'm
trying to separate the address from the city. Each cell has a different
length of address, but the same city name. Is it possible to, or what is
the easiest way, to separate the address and the city?

Here is a sample of my data:

A B
3700 Chestnut Pasadena
42 N. Hill Pasadena

I want it to be

A B
3700 Chestnut Pasadena
42 N. Hill Pasadena

--
Gary Beard