How to get rid of the city and state in the address?

I have a big data that contain address with city and state. Sample as follows (please note there is only space between each word, no other special symbol):
A1: 123 Furrows Rd Holbrook NY
A2: 456 New State Hwy (Rt 44) Raynham MA
A3: 789 Liberty Ave Brooklyn NY
A4: 101 Broadway Newburgh NY

How can I get rid of the city and state so that the cell A1 - A4 look like this:
123 Furrows Rd
456 New State Hwy (Rt 44)
789 Liberty Ave
101 Broadway

Many many thanks!

Ace_XL, thank you very much! One more question, some of cities have 2 words. Such as:
675 Broadway New York NY
How can I get it to show as: 675 Broadway

Maybe:
=LEFT(A2,LEN(A2)-LEN(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",50)),100))))