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.

Problem: 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:

enter image description here

and Here's the actual spreadsheet.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.