In Excel if you have a city in a cell, it is possible to go to Data tab and then choose Geography as data type.
This will allow to get map coordinates: longitude and latitude.
However, it might be able to recognize smaller cities, while some major cities are missing. For example, here are two cities in Hungary where it cannot recognize the capital. Similarly, it can recognize Stuttgart in Germany but not Berlin. My problem is that I have a VBA macro that calculates the distance between two cities, and I am using this method. Does anyone have any idea about the logic - why are some major cities missing? Thanks!
