$3$ The City$/$State data is organized with the city name, then the state abbreviation. For example, Prescott Valley NM where Prescott Valley is the city and NM is the state.

Split the City$/$State column into two individual columns, City and State. Remove the City$/$State field, if necessary.

Mac users, select the range D$2$:D$11.$ On the Data tab, select Text to Columns. Enter a hyphen $(-)$ as the dellimiter. In cell D$1,$ type City and in cell E$1$ type State.