In MS Excel, I need to separate text by comma, extract three things from right and put them in three different columns i.e. city, State and Country.
In the original text which is the full address, I sometimes get only the country or only the state. Also, the length of the full address is varied.
Here's a screenshot of what I intend to do:
and Here's the actual spreadsheet.