unexplained spaces in address labels in mail merge from excel

N

natalie

I have an excel doc that I am merging to word for address
labels. The merge is fine, except that on each label there
is a several-character sized space between the city and
state. ie, Los Angeles ,CA. I can't find out where
the space came from, but out of several hundred addresses
it is there on almost every one. I can't see a difference
in my worksheet between the ones with the space and
without it. I can't see how to fix without manually
editing each label, which isn't possible. HELP!
 
P

Peter Jamieson

Which version of Word/Excel, and how are you inserting your addresses?
Multiple fields, or an ADDRESSBLOCK field?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Mail Merge Makes One Page of One Name of One Label Instead 1
Label Merge Spacing 1
A way to mail merge from excel into a word label template? 0
Cannot print a mail merge document. 1
Word Merge labels 2
Mailmerge Labels - Line Spacing (2007) 1
Vexing problem with mail merge line suppression 3

Top