I want to extract the city & state from a cell that has the city, state and zip code.
The zip code may not always be 5 digits (either 90210 or 90210-1234) and the City and State may not always have a comma separating them.
A formula that can extract any text left of a numeric value is what would solve this, but I cannot figure it out or find anything in other posts.
Here is an example of what I'd want to return out of the first column.