Excel - Separation of Address Requirement

[Vinod GV]

Hi
In Column A, I get a file where I have address, city , state and Zip code in one single cell. I need to split them into separate
I need to manual separate them, rather looking for a code or formula which can separate them
I have shared the screenshot of the outcome required, can you please assist me on this.

 

[steve the fish]

You could get the state and zip but the rest isnt possible unless you maybe have a list of cities that it could be compared against. A machine cant know what a street or a city is and there is nothing there to separate them.

 

[Vinod GV]

This is floating, we are not sure on the ask of the address.
Can you please share the formula for atleast for Zip and state

 

[steve the fish]

As the zip and state are always of the same length and always at the end of the address you can use mid and right formulas such as:

=MID(A1,LEN(A1)-6,2)
=0+RIGHT(A1,5)

 

[Fluff]

Cross posted
While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.

Despite having being told before you are still ignoring the rules.
Please supply the link to the other site you have asked this question.