In the selection pane, they will show you the county for the two Sutters and you can choose. Note: This can also happen if there are two cities with the same name, such as Uniontown Ohio or Sutter Illinois. Select that cell and use the pane on the right side of the screen to do a search. If any cells have a circled question mark instead, you might have mis-spelled the city. From the Data tab of the Ribbon, click on Geography (shown below in Portuguese…your computer will show your default language).Įach cell should gain a Map icon. Select the range of cells containing cities. Make a copy first so your original cities can be used later.
The Data Type operation is a bit destructive and will change the text in the city cells. If you don't do a search for how to join the Office Insiders program.įirst, make a copy of your city data. Do you have a new Data Type category with Stocks and Geography? A new Geography Data Type feature coming to Office 365 will make this easy. Say that you have a list of cities in Excel and need to know the latitude and longitude for each city.
0 kommentar(er)
