text to columns
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
|