How to split one column address to street,city,houston,zip in excel?

Added 3+ months ago:

im sorry i met street,city,zip code

Added 3+ months ago:

i figure out how to take the zip code now i need just the city which is in end of the column

i tried right(A1,7) and it work but the city name still appears in last column too