Forum Discussion
Text to Column
Hello Everyone. I'm trying to split data into 2 columns. The original data is made up of cities and states: Notice that some items have a comma and others don't. Also, the cities states are d...
Another workaround is to convert the locations to Geography data types.
When the locations are converted to Geography Data types, Excel will usually keep the city and drop the state (except for New Mexico in this case). The state is then pulled through Admin Division 1.