help extracting specific words using mid and find functions

if i have an address in 1 single cell for example, 355 Two Tree St. Los Angeles, CA 94000, how can i use excel to extract just the city? and lets just assume that the city always comes after the street, meaning there is no "blvd" or "ave",etc. and the comma is always after the city?

this is what i have so far =MID(C8,SEARCH("st.",C8)+3,FIND(",",C8,FIND(" ",C8))-1-FIND("",C8))

but it always returns with the city, state and the zip, how do i eliminate the state and zip?

Please Login or Register  to view this content.