This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Never mind, figured it out. Sometime you just have to walk away and come back to it. My solution was to parse on the first space into two columns, parse on the hyphen, use the Replace formula to remove the Foods from the city name. Anyone have other faster or cooler ways to do this I'm definitely interested.