#VALUE! error in Word mail merge after using Geography to find zip codes and cities

[MikeTober]

Hi Everyone,

I am trying to create address labels from a spreadsheet. I used Data>Geography to find zip codes and cities. Now when I create the mailing in Word, the city and zip code return "#VALUE!". I've tried formatting the Geography cells as text, but the little map symbol remains in the cell and the same #VALUE! error returns in Word. 

Any ideas how to solve this error?

I am running macOS Big Sur version 11.2.3, and Excel for Mac version 16.48

Any help is greatly appreciated.

-Mike

[#2]

@MikeTober Don't really use this functionality myself, but try this.

Select all you Geography data typed cells. Copy and paste somewhere else as VALUES. Now select that pasted range. Right-click (or two-finger click on the touch pad). Select "Data type", "Convert to Text".

That removes the map icons and converts everything to flat text. On Big Sur myself, so it should work for you as well.