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

%3CLINGO-SUB%20id%3D%22lingo-sub-2317410%22%20slang%3D%22en-US%22%3E%23VALUE!%20error%20in%20Word%20mail%20merge%20after%20using%20Geography%20to%20find%20zip%20codes%20and%20cities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2317410%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20address%20labels%20from%20a%20spreadsheet.%20I%20used%20Data%26gt%3BGeography%20to%20find%20zip%20codes%20and%20cities.%20Now%20when%20I%20create%20the%20mailing%20in%20Word%2C%20the%20city%20and%20zip%20code%20return%20%22%23VALUE!%22.%20I've%20tried%20formatting%20the%20Geography%20cells%20as%20text%2C%20but%20the%20little%20map%20symbol%20remains%20in%20the%20cell%20and%20the%20same%26nbsp%3B%23VALUE!%20error%20returns%20in%20Word.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20how%20to%20solve%20this%20error%3F%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20am%20running%20macOS%20Big%20Sur%20version%2011.2.3%2C%20and%20Excel%20for%20Mac%20version%2016.48%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAny%20help%20is%20greatly%20appreciated.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E-Mike%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2317410%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2317481%22%20slang%3D%22en-US%22%3ERe%3A%20%23VALUE!%20error%20in%20Word%20mail%20merge%20after%20using%20Geography%20to%20find%20zip%20codes%20and%20cities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2317481%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1043672%22%20target%3D%22_blank%22%3E%40MikeTober%3C%2FA%3E%26nbsp%3BDon't%20really%20use%20this%20functionality%20myself%2C%20but%20try%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelect%20all%20you%20Geography%20data%20typed%20cells.%20Copy%20and%20paste%20somewhere%20else%20as%20VALUES.%20Now%20select%20that%20pasted%20range.%20Right-click%20(or%20two-finger%20click%20on%20the%20touch%20pad).%20Select%20%22Data%20type%22%2C%20%22Convert%20to%20Text%22.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-05-03%20at%2016.27.13.png%22%20style%3D%22width%3A%20409px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277484i7E7457129C4DBC1A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-05-03%20at%2016.27.13.png%22%20alt%3D%22Screenshot%202021-05-03%20at%2016.27.13.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThat%20removes%20the%20map%20icons%20and%20converts%20everything%20to%20flat%20text.%20On%20Big%20Sur%20myself%2C%20so%20it%20should%20work%20for%20you%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

1 Reply

@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".

Screenshot 2021-05-03 at 16.27.13.png

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