Labels and zipcodes

captpicky

New Member
Joined
Dec 1, 2005
Messages
3
When I try and merge my spreadsheet into Word to create mailing labels, i have a problem with the zip code. When i merge the field shows up with a M_66061. I cant get rid of the M_ I have tried different formats including text and zip code
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
Where is the "M_" coming from? Is it in the Excel file along with the zipcode number?
 

captpicky

New Member
Joined
Dec 1, 2005
Messages
3
The "M_" dosen't show up in the excel cell but when i mail merge it into word..it shows up as part of zip code.
 

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
Then in your Word document you have some stray characters. From menu go to:

Tools / Options

In the Options pane, choose the View tab. Enable all the various hidden codes so that you see exactly what is in the document. Once you've corrected the problem, go back & restore the normal state.
 

captpicky

New Member
Joined
Dec 1, 2005
Messages
3
still having problems...word will not even import the zip code. It shows up in the merge window that you use to select what fields you want to merge, but then nothing shows up in the final product.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,505
Messages
5,832,117
Members
430,111
Latest member
Francis Xavier

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top