Separating City Name From Addresses Without Delimiter

Hi

Excel 2013

I have a list of 4422 addresses where the city name is suffixed at the end of the address.

The problem is that there is no delimiter in front of the city names and the number of words in the City Name varies between 1-3

How could I split them up so that the city is in a new column.

Please find a sample list attached which shows how I have it and how I want it

Kindly advise

Thanks