Address and city splitting

Hi All,

I have the address associated with the city. Here I need to split the address and the city in tow different columns. And I also have the list of cities. Is there any formula to do so?

Example:

2001 Butterfield Rd Ste 1020Downers Grove
2001 Butterfield Rd Ste 1020Downers Grove
2001 Butterfield Rd Ste 1020Downers Grove
3210 Watling StEast Chicago
3210 Watling StEast Chicago
1050 Macarthur CswyMiami
1050 Macarthur CswyMiami
1050 Macarthur CswyMiami


Need to split like this


2001 Butterfield Rd Ste 1020 Downers Grove
2001 Butterfield Rd Ste 1020 Downers Grove
2001 Butterfield Rd Ste 1020 Downers Grove
3210 Watling StEast Chicago
3210 Watling StEast Chicago
1050 Macarthur Cswy Miami
1050 Macarthur Cswy Miami
1050 Macarthur Cswy Miami

I would count the characters(=LEN(refernce City cell)) from the list of the cities. and then use =right(reference cell, character length calculated before). Works only if the city is at the end.