Geography Data Type #CONNECT! error message when changing city to country

Copper Contributor

Screenshot (3).png Only getting an error with Paris to France and nothing else. I am in England so I don't need a VPN. I have the latest Windows and Office update too. Please help. If not solution is there a method where I can use a formal to read Paris and Print France in Column K.

2 Replies

@marylmurphy2001 

Looks like a bug. For Paris they added French First Republic as a country, but there is no such one among countries now.

image.png

Thank you! Is there a way to fix this? If not, is there a formula that reads my column H (City) and Prints the country in Column K. I.e. when it read Paris in H, Print France in K, without using the geography data type.